Is SQLite reading always getting to disk?

Question

I have a Pylons application using SQLAlchemy with SQLite as the backend. I would like to know whether every SQLite read operation will always lead to a hard drive reading (which is very slow compared to RAM), or whether some caching mechanisms are already involved.

• Does SQLite support a subset of the database in RAM for faster access?
• Can an OS (Linux) do this automatically?
• How many accelerations can be expected using a production database (MySQL or PostgreSQL) instead of SQLite?

Answer 1

• , SQLite . , PRAGMA cache_size. , , PRAGMA temp_store. API .

• SQLite - . . , sqlite.h .

• , , .

Answer 2

, (Mysql postgres) sqlite?

sqlite ? , :

Sqlite:

SQLite, , -. , , / SQLite.

SQLite ; SQLite ; ,