RE: [PHP] Speeding up PHP or MySQL
| From: | John Holmes | Date: | Thu, 25 Jul 2002 01:48:50 +0000 |
| Subject: | RE: [PHP] Speeding up PHP or MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-109398@lists.php.net to get a copy of this message | ||
> Is there anyways to speed up MySQL queries? Or showing the results
> through
> PHP? I have several queries that have about 8 left joins or so.. Yes
very
> huge and when you have lots of people using these functions at once it
> really slows down.. Are there any practices that you can think of that
> would
> speed up any sql queries? I was thinking of using stored procedures,
but
> after a bit of research I found ou= t that MySQL doesn=B9t have that
yet
> so
> that's a no go :( Or is there a way of storing common query results?
I
> am
> looking for _anything_ that will speed up showing results to large
> queries..
How about an index on your tables?
---John Holmes...