in reply to Re: BerkeleyDB and a very large file
in thread BerkeleyDB and a very large file

And use MyISAM instead of InnoDB or another option (I think there are more now?). It doesn't support foreign key and atomicity stuff but unless something has changed in the last couple years it's still the fastest relational DB and it can be tuned to your specific data if you know how.

Replies are listed 'Best First'.
Re^3: BerkeleyDB and a very large file
by perrin (Chancellor) on Aug 22, 2008 at 17:54 UTC
    InnoDB is usually faster for me, but for single key unique lookups like this I expect MyISAM will be better.