Re: [sqlite] Performance benchmarking

2003-10-27 Thread Danny Reinhold
> Danny Reinhold wrote: > > DRH tested inserts with and without transactions on several > > DBMSs. PostgreSQL and MySQL where faster _without_ > > explicit transactions. > > That looks a bit strange to me... > If you are referring to Test 1 and Test 2 at http://www.sqlite.org/speed.html, > please

Re: [sqlite] Journalling

2003-10-27 Thread ben . carlyle
Hello, v t <[EMAIL PROTECTED]> 27/10/2003 05:16 PM To: "Mrs. Brisby" <[EMAIL PROTECTED]> cc: sqlite <[EMAIL PROTECTED]> Subject:Re: [sqlite] Journalling > I am trying to use sqlite in a context where I will be using it to store some configuration

Re: [sqlite] Journalling

2003-10-27 Thread v t
I am trying to use sqlite in a context where I will be using it to store some configuration about a system. I want to try to minimize the disk access. Since journalling uses a file on the disk, I wanted to turn it off. I am not worried about rolling back the database to a known state in case of