> # At 04:56 PM 5/15/00, Diego Schvartzman wrote:
> # >I have an application via PHP. For example, a SELECT query that must return
> # >one and only one row, with a where clause with and index (I droped it and
> # >created again) that took about 3 seconds (v6.5.3), now (v7.0.0) takes about
> # >15 seconds. Really I don't lnow what is happening. Same hardware, same php
> # >version, etc etc.
> # >
* Dustin Sallings <dustin@spy.net> [000516 02:26] wrote:
> On Mon, 15 May 2000, Charles Tassell wrote:
>
> I ran into this exact problem, and it was *very* significant on a
> 15M row table I have. :) It didn't seem to want to use the index, even
> freshly created, without a vacuum analyze.
grrrr....
FOR THE LAST TIME, THESE BUG REPORTS ARE PRETTY MUCH **USELESS**
TO THE DEVELOPERS UNLESS YOU GIVE:
THE TABLE STRUCTURE,
THE QUERY, AND
THE OUTPUT OF 'EXPLAIN'
Just because someone is a database guru doesn't mean they are also
clairvoyant. :)
thanks,
-Alfred