Even though this topic may have already been discussed several times, I would like to address it. I think the “support” section here in the forum doesn’t quite fit. Please feel free to move it.
I am interested in a performance comparison (not discussion) between a Nextcloud MariaDB and Nextcloud SQLite installation. Maybe someone is interested in trying it out and reporting back here.
I find this particularly interesting for single-user installations and especially for the Files application. I would like to see this evaluated for large amounts of data or for a large number of files. For only a one-person-data-grave Nextcloud is SQLite an option or not (easy backup option).
Perhaps someone would enjoy trying this out on a test system with one user and perhaps 100, 1000, 10,000 or even more files. How does the performance change with MariaDB vs. SQLite? For GUI as well as for Nextcloud clients and WebDAV. It would also be interesting to know whether problems arise due to the size of the database and if so, when.
I would be happy to hear the results. I know that SQLite should only be used for small installations or for testing. But that’s not what this thread is about.
You are obviously interested, why don’t you want to do these tests?
If you can install a real DB on your system, just use the database and don’t bother with sqlite. If you can’t use a real DB, you don’t have a choice. For me it would make more sense to test, e.g. different databases, best config settings, impact of certain apps on the overall performance, …
so things that make a difference and that you can change (or report to developers to improve). If you can just use sqlite, you just use it until it is so painfully slow that you migrate to a different system.
There are tests for the performance: https://sqldocs.org/sqlite/sqlite-vs-mariadb/
Regarding Nextcloud, the performance depends a lot if you use caching or not, what kind of hardware, what kind of apps, …
I’d probably go more in the direction of checking the db structure of Nextcloud and the type of queries and then run a test on sqlite directly, if there are some ‘hard’ limits when it is degrades significantly.
I have tested it am i am still testing it. I will report on this. But I would also be pleased to hear about other people’s tests. I am specifically interested in Nextcloud as described above.
I have now tested it with 100 directorys, 1000 files and 300 MB. Works fine for me.
I think if you don’t have too high demands and are prepared to back up the Nextcloud in an emergency, the use of SQLite is not a limitation for small one-user installations, even if it is of course not recommended.
Because of a problem i have disabled filelocking.
'filelocking.enabled' => false,
As a single user Nextcloud and if you are prepared to restore a backup in the event of an error, this is less necessary.