Mike, I guess it all depends (ymmv etc.), but I'll give you some tips.
Query of queries are not really great if you're trying to speed things up. It's not the worst way to go, but if you make better original queries and minimize the number of QoQs, you'll do a bit better. Now the question is do you want to make a stored procedure or a query - SPs are generally a little better because their execution plan is precompiled, but they're typically not much better than queries with bound parameters (cfqueryparams for us). However, you may want to look into a database view, which actually caches the results of a query, which works great for huge amounts of data. Then, do you want to cache the query in CF? That depends on how often the data changes, how much data there is (over 1GB of one type of data probably shouldn't just be stored in java memory, imho), and if you can work around any problems there may be if and when the data changes. Then perhaps you can do some smarter caching of your data - cache a small part of it as it's requested, or cache just the most popular parts of your dataset, if possible. This could help you get around needing to do QoQ's. Last, remember you can cache your queries, even queries of queries, in a shared scope, for instance, your application, or better yet, a CFC in your application scope where you can control access to the data. Ok, well just some thought to muse over on one of my favorite subjects. (ok i have like 20 favorites). -- nathan strutz http://www.dopefly.com/ On 4/29/07, Mike | NZSolutions Ltd <[EMAIL PROTECTED]> wrote: > > Hi guys, > > I am working on an application to list properties. Just wanted some > opinions... > > Am I better to create a stored procedure of all listings (the aim is to > have > quite a few), then use a query of queries to get relevant listings eg. > feature/general/classfieds > > Or am I better to use a standard query to get all listings - cache it > using > cachedwithin and use a query of queries each time? > > Or am I right off the track - lol! > > Regards > Mike > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276566 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
