On Thursday, Jun 26, 2003, at 13:07 US/Pacific, Bryan Love wrote: > Wow, you have a lot going on here. It's no wonder it takes a while to > execute.... Is there any reason you do not want to run two queries > instead? > You are transferring the work load of the DB to the CF server in the > code > below - you should let the DB do what it does best.
Bryan's right here - and this goes back to my comment about Blake Stone's "Five Secrets": be lazy, defer object creation and initialization until you really need it. > You'll need one query to get the list of campuses and another to > display the > information about a chosen campus, right? That's how CF was meant to > work > best. If you lazy initialize the Campus CFCs on demand from the campus code, that might well be 'faster' (assuming your page doesn't require all the Campus objects on page one?). 'faster' in the sense that your first page won't get a big hit and the overall time will be spread over multiple pages perhaps. Again, a lot depends on how you are using this information. Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
