[Pkg-owncloud-maintainers] Bug#683569: owncloud: excessive use of fsync() with sqlite backend leaves performance unbearable

[shawn]

Package: owncloud
Version: 4.0.4debian-1
Severity: wishlist
Tags: upstream

Dear Maintainer,

I have a _very_ small contact list, maybe 50 contacts or so, and from using strace it seems that
owncloud calls fsync() twice for every contact, and it does it completely serially. As
I have this database on SD, it means it has taken over 10 minutes so far, and still has not completed.

Maybe a bulk import mode, where it just copies the database, or something that would probably be far better
is per-record locking and atomic support that comes with a database library like kyotocabinet/kyototycoon.

-- System Information:
Debian Release: wheezy
  APT prefers testing
  APT policy: (990, 'testing')
Architecture: armel (armv5tel)

Kernel: Linux 3.4.0-tomoyo-00006-gfd64aac (PREEMPT)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/dash

Versions of packages owncloud depends on:
ii  libjs-jquery          1.7.2+debian-2
ii  libjs-jquery-jplayer  2.1.0-1
ii  libjs-jquery-ui       1.8.ooops.21+dfsg-2
ii  libphp-phpmailer      5.1-1
ii  nginx-full [httpd]    1.2.1-2.1
ii  owncloud-sqlite       4.0.4debian-1
ii  php-crypt-blowfish    1.1.0~RC2-1
ii  php-getid3            1.9.3-1
ii  php-mdb2              2.5.0b3-2
ii  php-mdb2-schema       0.8.5-1
ii  php-pear              5.4.4-2
ii  php-sabredav          1.6.2-3
ii  php-xml-parser        1.3.4-6
ii  php5                  5.4.4-2
ii  php5-curl             5.4.4-2
ii  php5-gd               5.4.4-2

Versions of packages owncloud recommends:
ii  postfix [mail-transport-agent]  2.9.3-2+b1

owncloud suggests no packages.

-- Configuration Files:
/etc/owncloud/htaccess [Errno 13] Permission denied: u'/etc/owncloud/htaccess'

-- no debconf information