Re: Slow query
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 02 Jul 2008 15:40:45 GMT
Message-ID: <486ba17d$0$1347$834e42db@reader.greatnowhere.com>
Date: 02 Jul 2008 15:40:45 GMT
Message-ID: <486ba17d$0$1347$834e42db@reader.greatnowhere.com>
On Tue, 01 Jul 2008 21:34:31 +0200, astalavista wrote:
> Hi,
>
> Is it possible to speed up this query ?
Yes. Trace the query with the event 10046 and see what events are you waiting for. That will give you the idea what is your query waiting on and, probably, just probably, how to eliminate those waits.
-- http://mgogala.freehostia.comReceived on Wed Jul 02 2008 - 10:40:45 CDT