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

Re: What does the Indexing actually do?



On Thu, 4 Jan 2001, Matthew Hoskins wrote:

> This question may be more esoterical than practical...
>
> I am running a directory with 50000 entries and do multiple searches on the
> uid attribute.  Needless to say, without the indexing the search took
> incredibly long!  I indexed the uid attribute and the searches went from 2 -
> 3 minutes to less than a second!  My question really is -- What exactly does
> the indexing do?  I know it creates a seperate file with just the index
> information, but -- what is in that file that allows for such dramatic
> increases in performance?

This is basic database knowledge. I suggest you take a book about
databases and see what indeing does to databases.

Hugo.

-- 
Hugo van der Kooij; Oranje Nassaustraat 16; 3155 VJ  Maasland
hvdkooij@caiw.nl	http://home.kabelfoon.nl/~hvdkooij/
--------------------------------------------------------------
This message has not been checked and may contain harmfull content.