On Thu, 27 Jan 2005 11:16:13 +1100, Mark Mandel <[EMAIL PROTECTED]> wrote: > Now, in my mind - there are two options for getting the PersonBO > information and the AddressBO information. > > 1) Seperate SQL queries for both BO's... Better for the programmer, worse for the computer.
> 2) Joins between tables... Better for the computer, worse for the programmer. > What is your thoughts on this, guys? I would go with option #1. If the extra database hits were causing performance problems, I would consider #2. But there might be a better way to cut down on the number of DB hits, such as caching the results from the queries. Patrick -- Patrick McElhaney 704.560.9117 http://pmcelhaney.blogspot.com ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
