Cache database SQLite3 and "Unable to execute statement: database is locked"

Started by Massl, October 03, 2019, 12:28:09 PM

Previous topic - Next topic

Massl

Hi, in the error log I find many:
2: SQLite3::query(): Unable to execute statement: database is locked
/home/public_html/Sources/CacheAPI-sqlite.php (Riga 83)


Is it a configuration problem?
I only activated the cache database SQLite3

SMF 2.1 RC2 with default theme without mods.

Thanks  :)

Arantor

Don't use it, your site is possibly too busy for it to be good for you. Use one of the others instead.
Holder of controversial views, all of which my own.



Massl

I have activated APCu from PHP (7.3) and selected the APCu cache, it seems very fast.

albertlast

i did a small test run on a mid size smf 2.1 (nighty from today) setup,
APCu cache came on read performance benchmark 10750 and
PostgresCache got 10643 reads
non cache got 9341.

the diff of 100 reads i would say are more or less equal.

Like always had in mind that this is a synthetic benchmark.

Massl

Thanks, very interesting :)

I'd like to know the results of other caches to make comparisons, do you know where I can find more information?

Advertisement: