note 64842 added to ref.sqlite

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. ---- Server IP: 217.13.201.10 Probable Submitter: 217.91.101.116 ---- X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER autolearn=no version=2.64 ---- Manual Page -- http://www.php.net/manual/en/ref.sqlite.php Edit -- http://master.php.net/note/edit/64842 Del: integrated -- http://master.php.net/note/delete/64842/integrated Del: useless -- http://master.php.net/note/delete/64842/useless Del: bad code -- http://master.php.net/note/delete/64842/bad+code Del: spam -- http://master.php.net/note/delete/64842/spam Del: non-english -- http://master.php.net/note/delete/64842/non-english Del: in docs -- http://master.php.net/note/delete/64842/in+docs Del: other reasons-- http://master.php.net/note/delete/64842 Reject -- http://master.php.net/note/reject/64842 Search -- http://master.php.net/manage/user-notes.php