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
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,
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.
CREATE TABLE
[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 explain select
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 can
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 explain
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 only
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;
++--+--+-+-++
|
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