One query is (almost) always more efficient than three. You might also want to consider using a stored procedure and calling it with the <cfstoredproc> tag. Even faster that way.
-----Original Message----- From: Jason Rogoz [mailto:[EMAIL PROTECTED] Sent: Thursday, April 07, 2005 11:21 AM To: CF-Talk Subject: Performance Question 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:201882 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
