ORDER DESC vs. ORDER ASC exec time

2004-03-29 Thread Vadim P.
Hi all, Just noticed that a simple query that returns only 14 rows is 10X slower when ORDER .. DESC is used compared to ORDER .. ASC. The table has about 700,000 records, indexed on the field the table is being ordered by. Is this expected behavior? MySQL 4.0.18 running under OpenBSD 3.4

RE: ORDER DESC vs. ORDER ASC exec time

2004-03-29 Thread Donny Simonton
accurate numbers. Donny -Original Message- From: Vadim P. [mailto:[EMAIL PROTECTED] Sent: Monday, March 29, 2004 8:16 PM To: [EMAIL PROTECTED] Subject: ORDER DESC vs. ORDER ASC exec time Hi all, Just noticed that a simple query that returns only 14 rows is 10X slower when ORDER

Re: ORDER DESC vs. ORDER ASC exec time

2004-03-29 Thread Vadim P.
- From: Donny Simonton To: 'Vadim P.' ; [EMAIL PROTECTED] Sent: Monday, March 29, 2004 9:34 PM Subject: RE: ORDER DESC vs. ORDER ASC exec time Personally, it's an unexpected flaw that I hope one day will be fixed. But I'm not holding my breath, even though they seem to be planning

Re: ORDER DESC vs. ORDER ASC exec time

2004-03-29 Thread Matt W
- From: Vadim P. Sent: Monday, March 29, 2004 8:15 PM Subject: ORDER DESC vs. ORDER ASC exec time Hi all, Just noticed that a simple query that returns only 14 rows is 10X slower when ORDER .. DESC is used compared to ORDER .. ASC. The table has about 700,000 records, indexed

Re: ORDER DESC vs. ORDER ASC exec time

2004-03-29 Thread Vadim P.
tried. So maybe something is making DISTINCT + reverse index scan slow even if it's not packed... Matt - Original Message - From: Vadim P. Sent: Monday, March 29, 2004 8:15 PM Subject: ORDER DESC vs. ORDER ASC exec time Hi all, Just noticed that a simple query that returns only 14 rows