Re: Trouble optimizing a query

2003-06-07 Thread Becoming Digital
;[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

Re: Trouble optimizing a query

2003-06-07 Thread lists
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

Re: Trouble optimizing a query

2003-06-07 Thread Paul DuBois
At 22:29 +0200 6/7/03, <[EMAIL PROTECTED]> wrote: Hello everyone, I'm working with MySQL 3.23.41-log developing a chat application. I need to run a query, order the results in descending order, then get the last 0-15 entries that are less than 20 minutes old. The query and tables in question a

Trouble optimizing a query

2003-06-07 Thread lists
Hello everyone, I'm working with MySQL 3.23.41-log developing a chat application. I need to run a query, order the results in descending order, then get the last 0-15 entries that are less than 20 minutes old. The query and tables in question are explained at the bottom of this posting. In