Hi,
We are evaluating using sqlite for a huge database: around 1000 millions
records splitted into 200 files. Any experiences about this and
tricks/howto's?
The characteristics of our project:
* The environment is a Unix box (IBM pSeries 64 bit) with fast
(USCSI-3) disks.
* No record deletes
* Most of the (history) data will have a low update rate, and will
be used mainly for queries.
* Heavy inserts in active file (5000000 per day), closed every day
(no more inserts)
* Just two indexes on the data.
Regards,
Pedro Pascual
