|
|
Posted by jj on 10/31/05 23:13
There were none, so i added them , now it works great!
thanks
"Stefan Rybacki" <stefan.rybacki@gmx.net> wrote in message
news:3snbg9Fo8ge3U1@individual.net...
> jj wrote:
> > 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)
>
> Are there indices on the ids? What does Explain tell you?
>
> Regards
> Stefan
>
> >
> > THanks!
> >
> >
Navigation:
[Reply to this message]
|