Re: Hash Cache using Require

2004-12-04 Thread Tom Schindl
Perrin Harkins wrote: On Fri, 2004-12-03 at 11:17 -0800, Bill Whillers wrote: Am I more or less efficient than just creating the hashes directly from hitting the database everytime the application needs it? The database is *not* under heavy load, at all. If the data is small enough, loading it i

Re: Hash Cache using Require

2004-12-03 Thread Perrin Harkins
On Fri, 2004-12-03 at 11:17 -0800, Bill Whillers wrote: > Am I more or less efficient than just creating the hashes directly from > hitting the database everytime the application needs it? The database is > *not* under heavy load, at all. If the data is small enough, loading it into memory shoul

Hash Cache using Require

2004-12-03 Thread Bill Whillers
I recently ported a set of old CGI applications for mod_perl. Each script loads a few hashes from flat files (using "open") filled with plain rows of delimited data that rarely changes (~50k each). The hashes are built by iterating thru each file, row by row, assigning values to keys. All the f