Don't know about whether this is going to be faster, as I can't test your
database:
select vhs.*, p.price, s.studio, s.ID as sID, s.studioID, pr.videoID
from vhs,pricing p,studios s, performersRel pr
where p.priceID = vhs.price
and s.ID = vhs.studio
and vhs.ID = pr.videoID
and pr.performerID = 1627
-----Original Message-----
From: Stuart Duncan [mailto:[EMAIL PROTECTED]]
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)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
