I asked the question so here it is http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:40469
My concern is that sometimes we get too much or too little information from the database and end up making too many trips to the database. OR We end up writing too many queries to get the right amount of information we need. Sometimes I find myself writing too many similar queries or even the exact same one without knowing it. Since the database processes faster than Coldfusion, we would want the database to do most of the processing. So we end up with hundreds of queries for every condition we need - bad. It doesn't seem to have an easy answer. So we have to find the balance when to do what and it is not easy to find that balance either. OO is great for processing one record. It makes update so easy. But when multiple records involve, it is such a headache. Johnny > Does someone have the link to the previous thread where Sean explained > this? I can't find it and was paying scant attention when it was first > posted. Would come in handy for me. > > Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209252 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
