Re: [sqlite] Wierd problems with 3.2.1 under macosx 10.3.9

2005-04-22 Thread D. Richard Hipp
On Fri, 2005-04-22 at 13:30 +0200, Tobias RundstrÃm wrote: > > If you disable the F_FULLFSYNC, it will go much faster. > > Compiletime change or some pragma? > PRAGMA synchronous=NORMAL; > >>Secondly after holding the DB open and not sending any querys to it for > >>quite some time (3-4 hours)

Re: [sqlite] Wierd problems with 3.2.1 under macosx 10.3.9

2005-04-22 Thread Tobias Rundström
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 t

Re: [sqlite] Wierd problems with 3.2.1 under macosx 10.3.9

2005-04-22 Thread D. Richard Hipp
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

[sqlite] Wierd problems with 3.2.1 under macosx 10.3.9

2005-04-22 Thread Tobias Rundström
Hello, We (XMMS2 Team) have been using SQLite for quite some time now, it's used to cache metainformation about songs played. It can also be used to be searched and store addtional information. SQLite fits us very well and have been a good complement to xmms2. My primary platform is MacOSX and