The following query is in desperate need of optimization. Any gurus
out there who can share some insights, I'd greatly appreciate it.
I have a request table, from which I'm pulling all records. Each
request record has a part number, and for each requested part number,
I'd like to query the inven
Hi.
As I said, or at least, tried to say, a key over all used columns
should help. Adding the column from ORDER BY avoids the "using
filesort". Adding YIADDR (which I simply overlooked last time) should
add "using index", as I mentioned. This means, that the data file is
not touched at all, but o
ben,
I did that about three minutes after I got Davids email. Things seem to be
working a lot faster now, and the "using filesort" is gone. i am assuming
there isn't much more i can do to make this thing faster, but anything else
i can do would be awesome!
heres is the explain:
mysql> expla
Hi.
(I am replying to the wrong mail, because I already delete the one
from Steve...)
The slow part is probably the "using filesort". I am not sure, if it
will work, but try a key over all used column, i.e.
INDEX ( POOL, STATE, TIMESTAMP )
If it works (i.e. if MySQL correctly "sees" that it ca
Katen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 8:47 AM
To: Lopez David E-r9374c; [EMAIL PROTECTED]
Subject: RE: select query optimization
i made the change, but it looks like it didn't speed the query up at all.
here are the results from the first explain:
mysql> e
;-Original Message-
>From: Steve Katen [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, April 10, 2002 8:07 AM
>To: [EMAIL PROTECTED]
>Subject: select query optimization
>
>
>i have been working on getting this query as fast as possible and figured
>it was time to come t
8:07 AM
To: [EMAIL PROTECTED]
Subject: select query optimization
i have been working on getting this query as fast as possible and figured
it was time to come to the mailing list.
the below table currently holds about 43 thousand records with potential to
grow to around 1,000,000 records
i have been working on getting this query as fast as possible and figured
it was time to come to the mailing list.
the below table currently holds about 43 thousand records with potential to
grow to around 1,000,000 records.
CREATE TABLE `RADPOOL` (
`id` int(11) NOT NULL auto_increment,
Steve
Have you tried using compound index:
INDEX( POOL, STATE )
Just a thought.
David
-Original Message-
From: Steve Katen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:13 AM
To: [EMAIL PROTECTED]
Subject: select query optimization
i am running a basic install of
i am running a basic install of mysql version 3.23.49-log and i have a
pretty simple query that is not fast enough for my needs. any thoughts on
optimization would help.
the table description is below:
mysql> desc RADPOOL;
++--+--+-+-++
| Fie
10 matches
Mail list logo
