6 messages in com.mysql.lists.mysqlRe: Optimising a query on a large table.
FromSent OnAttachments
Rob Keeling23 Dec 2004 09:54 
kernel23 Dec 2004 10:41 
Rob Keeling23 Dec 2004 10:51 
Joerg Bruehe23 Dec 2004 11:46 
Donny Simonton23 Dec 2004 12:57 
Rob Keeling24 Dec 2004 04:35 
Subject:Re: Optimising a query on a large table.
From:Rob Keeling (ro@rjkeeling.freeserve.co.uk)
Date:12/23/2004 10:51:16 AM
List:com.mysql.lists.mysql

"kernel" <ker@nea-fast.com> wrote in message news:41CB@nea-fast.com...

Rob, Have you run "show full processlist;" to see if it is copying to a tmp table ??

walt

Nothing listed other than the query itself. Should have said its on Mysql 3.21.

Rob Keeling

--

I love deadlines. I love the whooshing noise they make as they go by. - Douglas Adams