Re: AW: [PEAR-DEV] RE: Re: Sqlite wrapper for Log package
| From: | Alexey Borzov | Date: | Sun, 04 Jan 2004 21:43:44 +0000 |
| Subject: | Re: AW: [PEAR-DEV] RE: Re: Sqlite wrapper for Log package | ||
| References: | 1 2 3 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-24747@lists.php.net to get a copy of this message | ||
Hi!
Pierre-Alain Joye wrote:
Excuse me? No DB will lock the whole table for *insert*. Even MySQL won't.sqlite isn't so fast when it comes to concurrent writes, as the whole DB file has to be locked. I'm not sure if I'd use it for writing logfiles.Indeed, but always better than other DBs
and it's the same problem for file based logs.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.