note 64842 deleted from ref.sqlite by bjori
| From: | bjori@php.net | 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.