Then I'd just run 1 query let sql do the work for you if you have the memory on the cf box to store it.
-----Original Message----- From: Tony [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2008 12:02 PM To: cf-community Subject: Re: cf question... weird i know 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:278169 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
