Re: OpenLDAP performance vs. PostgreSQL

[John Madden <jmadden@ivytech.edu>]

> > This is likely not enough cache.
>
> 50 Mb, not enough?

I would guess not.  What's the size of your databases?  If you've got enough 
RAM, make sure your cachesize is the equivalent.

> > Check the cachesize and idlcachesize options.  You should be able to have
> > "cachesize 20000" to hold the entire DB in memory.
>
> increasing both to 20000 didn't seem to make it better. :(

Yeah, you might not, if you're waiting on bdb all the time.  

> Hmm... I didn't actually think DBD::Pg really supported prepare/execute,
> but I can see that it started to with 7.4, so maybe it gives an
> advantage. (prior to 7.4 prepare was just client side sugar).

And I had no idea it didn't make a difference under 7.3 -- I've always coded 
as if they were separate.  Wonderful. :)

John



-- 
John Madden
Sr. UNIX Systems Engineer
Ivy Tech Community College of Indiana
jmadden@ivytech.edu