Russ -- I had debugging on. Turning it off reduced the average by about 500 ms on the 10000 record query, so that definitely helps some!
Dominic -- I'd love to see what you've got! Post them to this thread, or email them to me, whichever you feel comfortable with. Not sure with what's going on with all my duplicate posts... But my original post has come in three times to me. Hopefully it's just a problem with my mail server. If it's not, sorry everyone! I'll email Michael D to remove the duplicates. Jonathon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4