Jason Rogoz wrote: >I have a situation that could be implemented in two different ways and looking >to see which situation would be best: >I have 3 result sets that i need to obtain...i could query the database 3 >times to obtain each one or query the database once and then filter the result >in cf using cfquery...in the long run is the cfquery slower at filtering than >querying the db 3 times? lets say we would be dealing with 300-500 records in >total. > > Answer to all performance questions: It depends
But you may also be able to create a VIEW on the db, and simply query that. Or you could possibly use temp tables. It also depends on which physical machine is faster, your db server or your cf server (assuming they are on different machines). In general DB servers are usually better at filtering the data than cf would be. ______________________________________ Pete Freitag work: http://www.cfdev.com/ blog: http://www.petefreitag.com/ shop: http://www.dealazon.com/ Author of the CFMX Developers Cookbook http://www.petefreitag.com/bookshelf/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201898 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
