Thanks for your reply,
D. Richard Hipp wrote:
On Fri, 2005-04-22 at 09:10 +0200, Tobias RundstrÃm wrote:
First of all performance is TERRIBLE, without syncronous=off I see insert times of up to 1 second for one row?!
This is the F_FULLFSYNC issue. It's a sad hardware story and there is nothing that software can do to fix it. Google for the details.
If you disable the F_FULLFSYNC, it will go much faster.
Compiletime change or some pragma?
Secondly after holding the DB open and not sending any querys to it for quite some time (3-4 hours) I often get a corrupted database (error from SQLite is "database file is damaged or encrypted").
What do you mean "holding the DB open"? If you you do not send it any queries, you can you get an error? Please explain the problem in more detail.
Sorry I was unclear.
I open the database, do some inserts(). idle for 3-4 hours without closing the handle and then do some selects it will give me that error.
-- Tobias
