SQLite Forum

What does, if many threads and/or processes need to write the database at the same instant, mean?
Login
Can someone explain in detail what exactly this means?

> "If many threads and/or processes need to write the database at the same instant (and they cannot queue up and take turns"

I am making a web application where I know that I will not need a client/server architecture, however, the site will have about 500K visits a day where users will both read and write.

The writes are small writes consisting of ratings, i.e. storing a single integer in a table. Other writes are of similar type, single integers for statistics usage (did the user click on your shop?), etc.

I am considering using SQLite, but I don't quite understand if the above will cause a problem in my case.

Any advice and explanation will be greatly appreciated.

Kind regards