in reply to Re: Optimizing a MySQL Query in thread Optimizing a MySQL Query
Tim,
Thanks for the advice. I tried implementing the changes you suggested but that query still takes about 30 seconds to display the list on my website when the results number about 170 records. It only takes about 2 seconds to execute on the server. That makes me think it might possibly be a problem with data transfer. Do you have any more suggestions for me for finding out how to make this faster?
Thanks,
Axel
Re: Re: Re: Optimizing a MySQL Query
by Cine (Friar) on Aug 23, 2001 at 21:37 UTC
|
There are two possibilites. You either have a bandwidth problem, which is easily checked my running you script on the server and in case is performs the same that is not the problem, or you are using plenty of modules and you are running plain CGI. The latter is most likely the problem and you should consider looking into modperl.
T
I
M
T
O
W
T
D
I | [reply] |
|