> chances are they wouln't upgrade until 4.0 has been in use a while. Version 4.0.1 has been out since December 2001. Tell them that and you just might luck out.
Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, 07 June, 2003 17:28 Subject: Re: Trouble optimizing a query On Sat, 7 Jun 2003 15:33 , Paul DuBois <[EMAIL PROTECTED]> sent: > >This is a problem that is fixed in MySQL 4. If you can upgrade, that >should help you a lot. > >http://www.mysql.com/doc/en/News-4.0.0.html > That explains that. I was relying on the online docs and it didn't even occur to me that there might be a version discrepancy. Unfortunately, I'm operating on a shared university database server, and chances are they wouln't upgrade until 4.0 has been in use a while. How much of a penalty am I going to pay because of that filesort? If I understand the docs correctly, the filesort is only performed on entries that survive the WHERE clause. If that's the case, I'm assuming the speed hit would be minimized. One thing that still puzzles me: should the index have kicked in on the ASC query? or are my indexes designed badly? Thanks for the input! Jacob --- Msg sent via [EMAIL PROTECTED] - http://mail.statisticalanomaly.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]