RE: [sqlite] File size issue?

2007-04-11 Thread Kastuar, Abhitesh
> Are you using indices? Do you have an integer primary key > on the table, but the data is not inserted in key order? > Do you delete and insert records a lot? Yes, we do have indices on a combination of fields in the table and we do not guarantee insert of the data in

[sqlite] File size issue?

2007-04-10 Thread Kastuar, Abhitesh
Hi, I am running into some issues that seem related to the current database file size. Our application is periodically saving about 150MB of data to the database. Starting around the 30th interval or so, the time to insert the data grows significantly - it initially goes up by 3-4x but then