> > 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??? In this case one of the advantages of the DBMS is that it is one copy of the data that everyone shares. mma