Or, creating an object instance for each row to display data is not worth it. When i'm displaying a list to drill down into and edit data, i create the instance only for the record the user wants to edit. In my front ends, where i want to maximize performance, i generally use a factory to create and cache my gateways. That seems to speed things up nicely, even if i'm using multiple gateways to render a page.
 
n :)
 
 -----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Phil Cruz
Sent: Sunday, May 01, 2005 11:46 PM
To: [email protected]
Subject: Re: [CFCDev] Gateway Question

generally speaking, just return the raw query.  Creating an object instance for each row is not performant.

-Phil

On 5/1/05, Toth, Cory TMC <[EMAIL PROTECTED]> wrote:
I have been reading information on the DAO / Gateways for a DB Tier of an application. my questions is when requesting multiple rows from a table should I be creating a collection of objects that I can iterate through or should I just return the raw query.
 
Just wanted to see how other people here are handling this issue.
 
 
Cory
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.

CFCDev is run by CFCZone ( www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).

An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]

----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.

CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).

An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.

CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).

An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]

Reply via email to