Re: Slaves taking up 100% cpu

[Jeff Leung <jeffleung@mac.com>]

I'll have to look into this. Our performance is already pretty good without
the index. How much slower would I expect things to go without an eq index
as opposed to with one?

On 1/20/04 3:24p, "Quanah Gibson-Mount" <quanah@stanford.edu> wrote:

> 
> 
> --On Tuesday, January 20, 2004 3:16 PM -0800 Jeff Leung <jeffleung@mac.com>
> wrote:
> 
>> Simple: we don't do searches. All our queries are strictly exact match.
> 
> That would imply an "eq" index.  A query is a search.  If you ask the
> directory for an exact match and you don't have an eq index, it is going to
> spend a lot of time processing the request.  I'd suggest you spend some
> time setting up some indices...
> 
> --Quanah
> 
> --
> Quanah Gibson-Mount
> Principal Software Developer
> ITSS/TSS/Computing Systems
> ITSS/TSS/Infrastructure Operations
> Stanford University
> GnuPG Public Key: http://www.stanford.edu/~quanah/pgp.html
> 

-- 
Jeff
// Diplomacy is the art of saying 'nice doggy'
// until you can find a rock.