[EMAIL PROTECTED] writes: >Which database are you using? We're on SQL Server 7.0.
I should add that the query itself doesn't seem to be the problem -- it returns in a matter of seconds. The lag is almost certainly happening in the process of looping through the query results and appending each line to the file. Thanks. _______________ Wendy Copley Web Engineer [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
