Whenever I deal with thousands of records, I try to do as much as possible in the database.
Could you perhaps, add triggers or use transactions, maybe? You'd see a buttload of speed increase, to be not quite grammatical. But, skipping that (as the case may be, wisely) I've used a bit of javascript and a table with a row of empty cells. I use some division to figure out "records per cell", so to speak, and then when I "flush" the data, I use javascript to switch the empty cells to cells with a background, one by one, so it makes a nice little "progress bar". I found the basic idea somewhere on the web, and it works "good enough"- little more info than just a "spinner" (busy indicator), or what have you. Probably more than you were thinking of, but you could use the same idea, and just use a bit of javascript to change the value in one place, with each flush, while the page loads. Just a Random idea =] -- if you want/need more info, holler. On 3/6/07, b. van kerckhoven typed: > > well, I am actually passing the IDS to a delete-function (which has the ID > as parameter) > .... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:271820 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
