What attendance will a site on SQLite pull?

Question

SQLite

Apart from the rest, how SQLite will be a bottleneck, given that the database will work only for reading. The recording will take place several times a week in the format of adding news by the administrator.

Answer 1

It all depends on the structure and amount of data, the presence of indexes, the complexity of queries. In general, SQLite reads fairly quickly. The documentation says that up to 100,000 visits per day will definitely pull. Plus, you can put the database in WAL mode so that the write does not block readers, set the cache size to a larger size, and configure the storage of temporary tables in memory.