rather a mysql question
| From: | Ando Saabas | Date: | Fri, 03 May 2002 11:22:27 +0000 |
| Subject: | rather a mysql question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-95864@lists.php.net to get a copy of this message | ||
Sorry that this is more of a mysql question, but since most php
programmers use it a lot, i though i might find the answer without
subscribing to mysql list, here goes:
When i do a query from a big table using indexes,it takes for example 5
seconds. Now if i, after
some time repeat the query, the query takes about 0.5 secs.
So far i thought it was because of caching, but now i read mysql (v3.23)
doesnt
support query cache. So this really gets me wondering, where does the
speed increase come from?