On Thu, 2003-05-29 at 11:59, Marc M. Adkins wrote: > > > perhaps something such as copying the whole 800,000 rows to > > > memory (as a hash?) on apache startup? > > > > That would be the fastest by far, but it will use a boatload of RAM. > > It's pretty easy to try, so test it and see if you can spare the RAM it > > requires. > > Always one of my favorite solutions to this sort of problem (dumb and fast) > but in mod_perl won't this eat RAM x number of mod_perl threads???
No. If you load the data during startup (before the fork) it will be shared unless you modify it. - Perrin
