[Date Prev][Date Next]
Re: OpenLDAP performance vs. PostgreSQL
> > 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. :)
Sr. UNIX Systems Engineer
Ivy Tech Community College of Indiana