Re: AW: [PEAR-DEV] RE: Re: Sqlite wrapper for Log package

On Mon, 05 Jan 2004 00:43:44 +0300 Alexey Borzov <borz_off@cs.msu.su> wrote: > > Indeed, but always better than other DBs > > Excuse me? No :). > No DB will lock the whole table for *insert*. Even MySQL won't. Who said that? You should have read "even with this "problem" I'm pretty sure that sqlite is faster than most of the DBs around". However I have not ran any benchmark done to verify that. > I remember reading that 'a' mode of fopen() was specifically designed > to prevent these kinds of problems. Besides, you don't usually keep > other data in log files, while you do keep it in SQLite "database" > file. Concurrent write to a file is not possible. 'a' is used to get the seek pointer to the end of file and then quickly insert the datas at the end of the file (see the manual for more infos). This operation can be quit fast and hide a bit the lock side effects. pierre