RE: Efficient Select

2001-02-02 Thread Drew Wilder-Goodwin
So that looks like it does a select for all in table2 who DO have dedicated and just excludes those matches... thats an interesting way of doing it.. but that would still return a row for the other groups that the username belongs to in table2 right? so for instance if there is 2 entries in table

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. > >