Jay Sprenkle wrote:
On 3/16/06, Daniel Franke <[EMAIL PROTECTED]> wrote:
The original idea was to get rid of thousands of files to store their data
in one single container. Those (ASCII) files add up to approx 5GB ...
If so, are you trying to use a blender to stir the ocean?
You might reevaluate if you're using the right tool for the job.
That's my question: IS sqlite the right tool here? =)
Then I guess the right question is what are your goals? To make
maintenance easier?
Why were the thousands of files a problem?
It looks as if this is a problem of storing large amounts of simple
data. Is an SQL RDBMS the best way to do that? Would a simple, compact
index file be more appropriate? The key to selecting the optimal
solution is to know how the information is to be retrieved. Are the
data archived? That could affect whether using rotating databases would
be efficient.
