note 64842 deleted from ref.sqlite by bjori

From: Date: Fri, 21 Apr 2006 17:03:09 +0000
Subject: note 64842 deleted from ref.sqlite by bjori
References: 1  Groups: php.notes 
Request: Send a blank email to php-notes+get-108941@lists.php.net to get a copy of this message
Note Submitter: mg at evolution515 dot net Reason: useless ---- SQLite is fucking slow! Trying to insert about 5K of email addresses I can watch the file grow by 2KB/s on a Dual-2GHz CPU (Debian). If you plan using SQlite to replace the PHP Session in an AJAX environment -- don't use it! This could make sense because PHP-Session cannot deal with concurrent variable __set(); It just stores it's data in a serialized text file. If more than one PHP-Process would write to that Session, data would be overwritten. If you need in-time SQL-Features like GROUP or ORDER, SQLlite could make sense. But not for storing large amounts of data! Better use MCache or use MySQL Engine=Memory or something to store session or temporary data.

« previous php.notes (#108941) next »