How are you populating the table? Make sure it is inside a transaction. Also, for bulk inserts to SQLite, try:
PRAGMA synchronous=off;
PRAGMA journal_mode=off;
PRAGMA temp_store=MEMORY;

This won't help file size though. What sizes are we talking about?

If we have to move to BLOB, it will be much harder to propose it as a standard because that will significantly complicate the reading logic. At that point, the only reason I can think of to stick with SQLite is the built-in R*Tree support.


On 12/5/2010 2:09 PM, Sara Nasso wrote:
Hi guys,

I tested for range queries times on the DB using the DATA table (no BLOBs).

Problems related to DB size and time required to populate it still need to be solved. I haven't thought about it yet. I guess that populating would be quicker using C-language interface, but I have no clue about how to deal with the size! Probably the only solution is to move to BLOBs. Any ideas?

What to do next?