> 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.
That's news to me (not being facetious). I was under the impression that cloning Perl 5.8 ithreads cloned everything, that there was no sharing of read-only data. mma
