Ever had one of those weekends that are so great that it makes you forget everything
come monday morning. I did and now I cant read/understand anything about locking.
So this is the deal.
I need to delete all the records from 3 tables. They can have anywhere from 24,000 to
100,000 records in them depending on how long its been since they have been cleaned
out.
This is what Im doing. i do a select all to get a total record count (not my idea).
Next I do a delete all from table.
I do this for each of the 3 tables so this can be a real hog and has a problem with
killing the server.
With all this said, I think I want to use a cflock around each of the table cleaning
queries to keep the users from writing to the tables. What would be the best way to do
this?
Art
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
