>I have two files, one that only queries some data, another that querries >it and displays it.
Perhaps try this: Place the display code, the cfoutput tag pair, in a separate file test2.cfm, and place <cfinclude template="test2.cfm"> at the end of test.cfm. Then your debug output will show more detailed information for the two separate pieces of code. Do you have any other different queries hitting this datasource? Comparing execution times against other queries with that datasource might reveal something. That's about all I can think of right now. What type of database server is this datasource pointing to? What kind of datasource connection - regular JDBC set up through the CF administrator or is it third party? What version of CF are your running? Mike Mertsock Alfred University Web Team ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
