Concurrency automatically handled in sqlite?

On my server, to speed things up, I allocated a connection pool for my odbc SQL source.

What happens if two or more hosts want to change my data? Are these numerous connections automatically handled by sqllite?

+3
source share
2 answers

You can read this thread

If most of these concurrent accesses are read (e.g. SELECT), SQLite can handle them very well. But if you start writing at the same time, blocking competition can be a problem. Much will then depend on how fast your file system is, since the SQLite engine itself is extremely fast and has many smart optimizations to minimize competition. Especially SQLite 3.

For most desktop and laptop / tablet / phone applications, SQLite is fast enough as there is not enough concurrency. (Firefox makes extensive use of SQLite for bookmarks, history, etc.)

- , (, , ) 100 . , , , 95% - - SQLite.

/, SQLite . RAM , .

+2

: .

:

SQLite , .

.

: .

+2

All Articles