Why does query hang? [was: Why does 1st query take so long?

2001-01-16 Thread John Stumbles
On Tue, 16 Jan 2001, Jeremy D. Zawodny wrote: On Tue, Jan 16, 2001 at 08:21:19PM +, John Stumbles wrote: I can't readily reproduce the first-time big difference scenario. OK, I can now: I have a table - MAC_connections:Data records:6689

Re: Why does query hang? [was: Why does 1st query take so long?

2001-01-16 Thread Drew Wilder-Goodwin
what does a 'show processlist' reveal? On 17 Jan 2001 00:08:23 +, John Stumbles wrote: On Tue, 16 Jan 2001, Jeremy D. Zawodny wrote: On Tue, Jan 16, 2001 at 08:21:19PM +, John Stumbles wrote: I can't readily reproduce the first-time big difference scenario. OK, I can