Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:3133 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 65647 invoked from network); 1 Jul 2003 23:53:44 -0000 Received: from unknown (HELO hasele) (216.179.74.133) by pb1.pair.com with SMTP; 1 Jul 2003 23:53:44 -0000 Received: by hasele (Postfix, from userid 1000) id B37424EA56; Tue, 1 Jul 2003 19:31:54 -0400 (EDT) To: Sascha Schumann Cc: internals@lists.php.net, Wez Furlong In-Reply-To: References: <1057087738.1360.216.camel@hasele> <1057101229.1360.303.camel@hasele> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-ID: <1057102314.4160.312.camel@hasele> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.0 Date: 01 Jul 2003 19:31:54 -0400 Subject: Re: [PHP-DEV] Removing SQLite sessions from the default distribution From: sterling@bumblebury.com (Sterling Hughes) On Tue, 2003-07-01 at 19:45, Sascha Schumann wrote: > Having a SQL session storage module in the default > distribution is a good learning example for other storage > module authors. I don't see any necessity to remove this > particular piece of code based on the assessment that it > does not outperform simple file access on Linux. SQLite It doesn't give you any benefit, that's my problem. People will use it to replace files, when in fact its no good. Its a fine candidate for PEAR or PECL, just like the postgresql session handler. As for a reference implementation, I've written C session handlers before, and files or MM are fine for reference implementations. > could very well be faster on synchronous filesystems where > creating new files is more expensive than in your testcase. I highly doubt that, and besides, what percentage of php users use those filesystems for sessions? Because session *creation* is not the issue here. In real world usage, you would hope most of your time is not spent creating sessions. Besides, on a synchronous filesystem, you'll probably have a much larger disk sync overhead with sqlite (shown by the benchmark where PRAGMA SET synchronous = ON was set). -Sterling > > - Sascha -- "Science is like sex: sometimes something useful comes out, but that is not the reason we are doing it." - Richard Feynman