[Owncloud] SQLite vs MariaDB/MySQL

[Jakub Moscicki]

Hello,

As a user I don't know the product strategy of Owncloud Inc. but technically it is completely clear that sqlite could only be useful for small single user installations (like on your NAS at home) or demos.

For anything bigger you should go for a real database, gradually scaling the setup (from db collocated with the web server, then dedicated db server finally dedicated db cluster). The DB schema shipped with owncloud is not optimized so you need to do that yourself (indices,partitions,…) according to your usage. If you can install mysql./mariadb easily on your system then I would actually recommend that you always do that rather than sqlite. This may be collocated with the web server if you have just on web server anyway… That's the minimal reasonable setup IMO.

Sorry I don't have benchmarks at hand but not sure if this real needs benchmarking ;-)

Regards,

kuba

--

On Jan 11, 2014, at 1:58 PM, Otto Kekäläinen <otto at seravo.fi>
 wrote:

> 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
> _______________________________________________
> Owncloud mailing list
> Owncloud at kde.org
> https://mail.kde.org/mailman/listinfo/owncloud