why not write both and time the execution? -----Original Message----- From: Jason Rogoz [mailto:[EMAIL PROTECTED] Sent: 07 April 2005 16:21 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 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
