> In theory the use of query or query should perform > better - the actual difference you see will be > influenced by amount of data actually being returned, > network traffic and so on....you can always test it > to see the actual difference. One big advantage that > CFSQL offers is that you only having to hit the database > once.
In theory, you're right. Someday, I want to move to Theory; everything sounds so nice there. In my experience, your mileage with query-a-query will certainly vary. I've tried using it in this way, and found it faster in several cases (significantly faster, under load testing) to just query the database. It seems that the advantage of being able to pull from local memory is often outweighed by other factors. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
