|
|
Posted by jj on 10/31/05 20:32
Hi !
I have a query that i run on my website, heres the pseudo code:
select
bottle_caps.caps_id,
products.products_id,
products.products_name,
products.products_image,
products.products_image_hi,
products.products_status,
price.price_option,
price.price
from
bottle_caps, products, price
where
products.products_model = price.products_id
AND
price.products_id = bottle_caps.caps_id
AND
bottle_caps.bottle_id = $sub_products_id
It works fine except for the fact that it takes about 3 seconds to execute.
So there is a little bit of a hiccup on my site when this code is loaded.
Im wondering is there something I could do to this SQL statement to make it
execute faster?
(the 3 tables are all about 2-4 thousand rows each)
THanks!
Navigation:
[Reply to this message]
|