List: | Internals | « Previous MessageNext Message » | |
From: | Timothy Smith | Date: | September 6 2001 2:16pm |
Subject: | Re: ORDER BY ... DESC LIMIT 1 optimization ? | ||
View as plain text |
On 2001 Sep 06, Fournier Jocelyn [Presence-PC] <joc@stripped> wrote: > It doesn't change anything, the query is still slow. OK, I believe that the optimization is not being done because MySQL doesn't realize that the ORDER BY is on the second part of the same key that is used for the WHERE clause. This might not be easy to fix in a general way, but we will look into it. Tim -- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Tim Smith <tim@stripped> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-time Developer /_/ /_/\_, /___/\___\_\___/ Boone, NC USA <___/ www.mysql.com
Thread | ||
---|---|---|
• ORDER BY ... DESC LIMIT 1 optimization ? | Fournier Jocelyn [Presence-PC] | 5 Sep |
• Re: ORDER BY ... DESC LIMIT 1 optimization ? | Timothy Smith | 6 Sep |
• Re: ORDER BY ... DESC LIMIT 1 optimization ? | Fournier Jocelyn [Presence-PC] | 6 Sep |
• Re: ORDER BY ... DESC LIMIT 1 optimization ? | Fournier Jocelyn [Presence-PC] | 6 Sep |
• ORDER BY ... DESC LIMIT 1 optimization ? | Michael Widenius | 6 Sep |
• Re: ORDER BY ... DESC LIMIT 1 optimization ? | Paul Cadach | 6 Sep |
• Re: ORDER BY ... DESC LIMIT 1 optimization ? | Fournier Jocelyn [Presence-PC] | 6 Sep |
• Re: ORDER BY ... DESC LIMIT 1 optimization ? | Paul Cadach | 6 Sep |
• Re: ORDER BY ... DESC LIMIT 1 optimization ? | Fournier Jocelyn [Presence-PC] | 6 Sep |
• Re: ORDER BY ... DESC LIMIT 1 optimization ? | Timothy Smith | 6 Sep |
• Re: ORDER BY ... DESC LIMIT 1 optimization ? | Michael Widenius | 6 Sep |
• Re: ORDER BY ... DESC LIMIT 1 optimization ? | Michael Widenius | 16 Jan |
• Re: ORDER BY ... DESC LIMIT 1 optimization ? | Paul Cadach | 6 Sep |