> > 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 [EMAIL PROTECTED]
