Re: very slow queries sometimes with alias deref always and scope sub

["COMBES Julien - CETE Lyon/DI/ET/PAMELA" <julien.combes@i-carre.net>]

> On Dec 20, 2007, at 12:48 PM, Quanah Gibson-Mount wrote:
>> The fact that it is sporadic and not consistent would seem to me to
>> indicate that there's something else going on here.

I'm agree...

>>  Have you examined
>> what's happening to your servers during the slow times vs the fast 
times?
>> I.e., more clients doing queries? etc.

All the servers are used differntly : differents applications from 
differents networks.

The problem happens simultaneously on all servers but load-average and 
cpu-usage are normal on all servers during the problem. Only servers 
used by applications who make a massive usage of alias deref always have 
there load-average increase during the problem


Le 20.12.2007 20:03, Chris G. Sellers a écrit  :
> Is your issue indexing related.  Are you searching items that may or may 
> not be indexed?

I don't think that the issue is indexing related because the request is 
done quickly when it is done with alias deref never.

>  Are doing doing a lot of adds that take indexing time 
> while you are doing the searches?

I haven't see a massive add of entries during the problem.

Regars,
Jlien