I can't say I've ever compared them, however, the information was something
that came from a Performance Tips session by Ben Forta at a recent
developer conference. Structures, Arrays and Lists, in that order.
At 15:14 2/06/00 +0000, you wrote:
>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.