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:349218
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
