Why is SQLite suitable for the template cache?

Question

The benefits of using SQLite storage for the template cache are faster to read and write operations when the number of cache elements.

I haven't used it yet, but how to use SQLite faster than a regular file system?

IMO overhead (initiating a connection) will slow down.

By the way, can anyone provide a SQLite demo?

Answer 1

There is no real concept to initiate a connection: the SQLite database is stored as a single file in the local file system; therefore, there is nothing like a network connection.

, SQLite , ( ), - ; .

" SQLite", , , SQLite API, ; SQLite DB : :

• "" -
• SQL-

: , - .

Answer 2

SQLite . SQLite . , , , .

SQLite . SQLite, . 30 ( 1 - ).