I was wondering if anyone knows of a way to speed up this query? If "Joins"
would be better, and how? That sorta thing.
The actors, studios and prices are all in separate tables. "vhs" "pricing"
"studios" and "performersRel"
There has to be a faster way to get 22 records back.
resultsbyperformer (Records=22, Time=328ms)
SQL =
select vhs.*, p.price, s.studio, s.ID as sID, s.studioID
from vhs,pricing p,studios s
where p.priceID = vhs.price
and s.ID = vhs.studio
and vhs.ID in (select videoID from performersRel where performerID = 1627)
Any help would be greatly appreciated.
Stuart Duncan
MaracasMedia Inc.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
