Re: [Owncloud] SQLite vs MariaDB/MySQL

2014-01-12 Thread Otto Kekäläinen
Hello, 2014/1/12 Chris : >>I also tried to migrate to MariaDB but failed and posted my >>experiences at > http://fabianpeter.de/cloud/owncloud-migrating-from-sqlite-to-mysql/#comment-6325 > > see the warning/disclaimer at the top of this howto and > the forum thread here: > > https://forum.ownclou

Re: [Owncloud] SQLite vs MariaDB/MySQL

2014-01-12 Thread Klaas Freitag
On 12.01.2014 15:42, Sebastian Kügler wrote: On Saturday, January 11, 2014 13:18:33 Jakub Moscicki wrote: Sorry I don't have benchmarks at hand but not sure if this real needs benchmarking ;-) Playing devil's advocate here: I really like the option to use sqlite instead of MySQL, for the fo

Re: [Owncloud] SQLite vs MariaDB/MySQL

2014-01-12 Thread Sebastian Kügler
On Saturday, January 11, 2014 13:18:33 Jakub Moscicki wrote: > 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 y

Re: [Owncloud] SQLite vs MariaDB/MySQL

2014-01-12 Thread Chris
Hi, >I also tried to migrate to MariaDB but failed and posted my >experiences at http://fabianpeter.de/cloud/owncloud-migrating-from-sqlite-to-mysql/#comment-6325 see the warning/disclaimer at the top of this howto and the forum thread here: https://forum.owncloud.org/viewtopic.php?f=23&t=18423

Re: [Owncloud] SQLite vs MariaDB/MySQL

2014-01-12 Thread Otto Kekäläinen
2014/1/12 Bernhard Posselt : > https://github.com/owncloud/core/pull/3052 Thanks for the pointer. I replied in https://github.com/owncloud/core/pull/3052#issuecomment-32121561 I also tried to migrate to MariaDB but failed and posted my experiences at http://fabianpeter.de/cloud/owncloud-migratin

Re: [Owncloud] SQLite vs MariaDB/MySQL

2014-01-12 Thread Otto Kekäläinen
(replying back to list) Yes I know this. I am not interested in a solution that works only for me, I want a solution that is best for everybody thus I suggest the by default OwnCloud packages should install MariaDB and not sqlite. 2014/1/12 Bernhard Posselt : > Basically don't use sqlite. The onl

Re: [Owncloud] SQLite vs MariaDB/MySQL

2014-01-11 Thread Otto Kekäläinen
2014/1/11 Jakub Moscicki : > At the same time the web navigation (via the browser) should be not > suffering at all (how to measure that?). > > Well, it's not trivial to define what's meaningful. The place where speed matters the most, is the UI. It must be quick so that users don't have to wait a

Re: [Owncloud] SQLite vs MariaDB/MySQL

2014-01-11 Thread Jakub Moscicki
I also don't think, that this needs benchmarks. Nevertheless benchmarks to measure the performance of owncloud would be nice to have. With those we could see, how changes on the code improve or degrade the performance. Agreed. For me it is not clear WHAT to measure. Upload/download times in the f

Re: [Owncloud] SQLite vs MariaDB/MySQL

2014-01-11 Thread Daniel Danger
Hi, On 01/11/2014 02:18 PM, Jakub Moscicki wrote: > Sorry I don't have benchmarks at hand but not sure if this real needs > benchmarking ;-) I also don't think, that this needs benchmarks. Nevertheless benchmarks to measure the performance of owncloud would be nice to have. With those we could s

Re: [Owncloud] SQLite vs MariaDB/MySQL

2014-01-11 Thread 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 setu

[Owncloud] SQLite vs MariaDB/MySQL

2014-01-11 Thread Otto Kekäläinen
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 OwnClo