Choosing the right database-system for a small project

[Thomas Güttler]

Thomas Weholt ( PRIVAT ) wrote:

> I've got a rather small project, small in the sense that there's not a lot
> of different tables needed in the database/storage-system, but there will
> be alot of data and the clients must be able to scan thru huge amounts of
> data very fast ( Not serial scanning, but lookups by key, preferrably
> several keys pr record, ie. I need to lookup people both by SSN and by
> first/last-name etc. )

Hi!

Why not use ZODB? The BTrees module gives you a dictionary-like
object which can store your list even when it is bigger than
the available memory.

The drawback is, that you need to pack the database from time to
time if you change objects.

 thomas