> In general is it better, from a performance standpoint, to > use one large and complex query to retrieve data or several > smaller and less complex queries when possible?
In general, there's no correct answer to this question. In some cases, it'll be better to do more work in one query rather than many; in other cases, it won't. In most cases I've encountered, when a lot of queries are used, often those queries can be consolidated into fewer, more efficient SQL queries, but that's primarily because the queries were written by people who didn't know SQL all that well. There is more overhead in running two queries, all other things being equal, but it's rare that "ceteris paribus" applies in real life. It's difficult to ask meaningful questions about general performance, I think, because there are very few cases in which one method of doing something is consistently superior to another (excluding the cases in which something is just done badly). Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
