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 index nodes

Bad optimization on ORDER BY .. DESC.

2001-07-25 Thread Artem V. Ryabov
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??? Why I can't use key value in select like that: select * from TableName where KEY(KEYNAME)concat('value1','value2') or select * from

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 is a known