Patrick Dunnigan wrote: > I am currently using SQLite to process @ 400 million records (and climbing) > a day by reading files, importing them into SQLite, and summarizing. The
Wow! How much memory those 400 milion of records is using ? Do you use Sqlite 2 or 3 version ? I was told that SQlite 3 has much lighter overhead in record size then Sqlite 2. Is that true ? How much is larger SQlite memory Btree then simple C/C++ structure ? Does it make sense to create index on memory table ? Best regards Boguslaw Brandys