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. > 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. -- D. Richard Hipp <[EMAIL PROTECTED]>
