To say briefly all this speed of SQLite is rather theoretical. It was extremely slow when I tried to use it. By insert into the 1st table SQLite locks the ENTIRE base. I think no other comments are needed??¦
P.S. START TRANSACTION locks as well (it simply locks; even doesn??™t let to read) the entire base

In fact SQLite is installed easily but I cannot say it is fast. But you are to make tests with the same MySQL, for instance. But it is not very convenient to work with, it??™s true. And there are no data base servers??™ advantages.

Gentlemen! Don??™t confuse yourselves! No one would dare to say that SQLite is able to compete properly with MySQL. And no one would say neither that MySQL can compete with Oracle. Each of them has its own field of application. Example with guest book is not given in vain. You must agree that lots of sites don??™t need DBMS in its direct meaning in fact but they have to save some data and have ability for data search and their periodical refreshing. For these purposes SQLite exists which is meant to make easier lives of those people who have no bent to global, volumetric and cool??¦

This wonderful solution is sure to find its grateful users. And many of its opponents are going to change their point of view having faced more primitive tasks.

The article is interesting but there is nothing about paginal spacing in SQLite