nah, two diff
also, whats wrong with my notation in naming the query here?
<cfset session.dataQuery_"#o[1]#" = queryNew("Name, IpAddressNumber,
IdleSeconds, Address, City, State, Zip, Place, PlaceId, BeginTime,
EndTime") />
thanks!
-- tony
Better than a thousand hollow words, is one word that brings peace.
-- siddhartha gautama
On Mon, Nov 3, 2008 at 11:48 AM, Scott Raley -ITC <[EMAIL PROTECTED]> wrote:
> Everything on the same box? Cf and sql server?
>
> -----Original Message-----
> From: Tony [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 03, 2008 11:26 AM
> To: cf-community
> Subject: cf question... weird i know
>
> if you had 10000 rows for a queryNew() query you were going to
> construct to store in memory from a cfc to a display layer template
> but you could logically break that down to 5 queryNew() queries, of
> 2000 rows each, one for each vehicle in this instance
> and store them, would you be better off performance wise when displaying
> them?
>
> cause id only need to show 1 of them at a time
> the other 4 would still just be hanging out in memory
>
> if i stored them all id prolly use a query of query to get the data
> for the individual ones, and then display that new query...
> on the other hand, i would just be reading its specific query and not
> making that qofq call.
>
> which would be best performance wise of top of ya head?/
>
> thanks!
>
> -- tony
>
> Better than a thousand hollow words, is one word that brings peace.
> -- siddhartha gautama
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:278163
Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
