Jacob- I agree with Mike that it might make more sense to just cache each ListCompanyDVD call rather than rely on QoQ. I don't really like using QoQ for this purpose and really very rarely use QoQ at all.
If you ar eon CF9 you could even use EHCache to store these queries instead of the default query cache and they can even persist beyond a server restart (if you want them to). Lastly, depending on how often your data changes, I'd also consider caching the actual HTML output (EHCache again if you can use it) and just leaving the Database calls all live and uncached. -Cameron On Mon, Dec 19, 2011 at 6:50 PM, Jacob <[email protected]> wrote: > > It this right? I thought if your cached a query there would be no > execution > time for the cached query. If I do not cache it, it takes about 4 seconds > to run. I am trying to speed up a section of our site. This is a master > query and I use query of a query to reference it. > > Master query > > DVDList (Datasource=xxx, Time=672ms, Records=116765, Cached Query) > Select a.stock, a.title, a.company, , a.releasedate, b.starring > From DVD a, DVDstarring b > where a.stock = b.stock and releasedate < '12/19/2011' > order by a.releasedate DESC, a.title > > Detailed query > > ListCompanyDVD (Datasource=, Time=31ms, Records=1519) > SELECT stock, title, company, releasedate, starring > FROM DVDList > WHERE company=? > > Query Parameter Value(s) - > Parameter #1(cf_sql_char) = VIV > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349220 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
