Re: Bad optimization on ORDER BY .. DESC.

2001-07-28 Thread Jeremy Zawodny
On Wed, Jul 25, 2001 at 12:03:59PM +0400, Artem V. Ryabov wrote: > Hello All, > > When I use "order by .. DESC" in query, time always more then in > "order by .. ASC" case. > Explain say "Using filesort",in "DESC" case query. > > Why??? Because in 3.23.xx, MySQL doesn't know how to walk the

Re: Bad optimization on ORDER BY .. DESC.

2001-07-25 Thread Sinisa Milivojevic
Artem V. Ryabov writes: > Hello All, > > When I use "order by .. DESC" in query, time always more then in > "order by .. ASC" case. > Explain say "Using filesort",in "DESC" case query. > > Why??? > > -- > Best regards, > Artem mailto:[EMAIL PROTECTED] Hi! This i