Yup...from what I understand, this is an area that they're working on
improving for the next version of ColdFusion.
-Kev
> -----Original Message-----
> From: Won Lee [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 02, 2000 11:15 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Another question on performance
>
>
> Incorrect -
> Arrays are faster by a factor of about 4. Structures are really slow.
>
> >If the "extra fields" are computed from other fields in the SQL query
> >and/or external data (known at the time of the query), you might
> >consider computing these fields as part of the SQL query itself...
> >using scalar functions or T/SQL statements (SQL Server).
> >
> > From what I have heard/read/experienced, the SQL engine can probably
> >do this a lot more efficiently that any CF routines you could write.
> >
> >Dick
> >
> >
> >At 10:10 AM +1000 6/1/2000, Nick Slay wrote:
> >>ok... so when it comes to performance, it's better to use
> strutctures than
> >>arrays and both of those are better than lists. But what about
> >>queries? Queries that are generated using QueryNew as opposed to SQL
> >>statements.
> >>
> >>I have a SQL Query result set that I need to loop through, calculate a
> >>bunch of extra fields, and then store that off for looping
> through later.
> >>
> >>At the moment I create a new query, take the fields I want from the SQL
> >>result set, and add them, plus the new fields into a new query.
> There are
> >>probably more efficient ways of doing this...
> >>
> >>Does anyone know whether creating another query, and looping through it
> >>later is going to be better or worse than creating an array of
> structures
> >>and looping through those instead? For that matter would I be
> better to
> >>add a column to the query that I got from SQL Server, and then
> loop through
> >>that again?
> >>
> >>Thanks for any feedback!
> >-----------------------------------------------------------------
> -------------
> >Archives: http://www.eGroups.com/list/cf-talk
> >To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
