[Typo3-dev] typo3 and sqlite (said to be twice faster than mysql)

[Martin Seebach]

Venlig hilsen
Martin Seebach

Adrien Laurent wrote:
>I've read that sqlite is twice faster than mysql

SQLite is faster than MySQL in doing many inserts in a transaction.
TYPO3 really doesn't ever do this. And if I'm not mistaken, it doesn't
use transactions - in which case SQLite is slower than MySQL. At the
task of doing selects with an index (which is really what any CMS does
for a living), SQLite is only maginally faster.

>I would like to know if it is possible to make typo3 working with sqlite, 
>and will it be a big job ? do I need to convert only "class.t3lib_db.php" ?

Making TYPO3 database-independent is a work in progress, see
http://typo3.org/projects/database-abstraction/

SQLite is nothing more than a smart way to store and access data in flat
textfiles, and was introduced in PHP5 because for a lot of the small
hobby projects and minor webpage dynamic, that PHP if often used for, 
you just need to store and retrieve a few single values - for which 
MySQL is overkill.


Venlig hilsen
Martin Seebach