[Date Prev][Date Next] [Chronological] [Thread] [Top]

Re: performance - how to index for most performance

Today at 4:35pm, christian gattermair wrote:

> what do i have to index for best performance: each field or everything in a
> line.

For best performance you need to index what is being used as search
keys.  You can either figure that out by harassing the people who wrote
the applications doing the searching, or by examining your logs
(assuming you have slapd write them) for what is being searched on.

It is my opinion, that you would do well to get a starting point from
the application developers, but realize they are going to lie to you and
examine your logs to fine tune your indexes.

Frank Swasey                    | http://www.uvm.edu/~fcs
Systems Programmer              | Always remember: You are UNIQUE,
University of Vermont           |    just like everyone else.
        === God bless all inhabitants of your planet ===