[Owncloud] SQLite vs MariaDB/MySQL

Otto Kekäläinen otto at seravo.fi
Sat Jan 11 12:58:59 UTC 2014


Hello,

Have you done any benchmarks on OwnCloud with SQLite vs.
MariaDB/MySQL? How does it perform? At what stage is real SQL server
preferred? Why is SQLlite at all used, why not always default to
MariaDB/MySQL, don't they give superior performance?

SQLite is easier to install, but anyway OwnCloud need Apache/Nginx+PHP
and other "big" stuff and MySQL installationis anyway highly automated
in all modern distros. What matters more is how *good' OwnCloud is,
and you don't want to have a crappy database to give users impression
that OwnCloud is slow/buggy (due to locks in DB)?

Or do you have benchmarks that show that SQLite is only a little
behind in performance, and where are those benchmarks?

- Otto



More information about the Owncloud mailing list