Re: [SQLite] Use of db:exec cause 5 second delay

[Gilles Ganault <gilles.ganault@...>]

On Wed, 29 Jan 2014 14:50:24 -0500, "D. Matt Placek"
<atomicsuntan@gmail.com> wrote:
>It also can depend on the file system you're using; at one point I had
>horrible delays with sqlite on ext4 where ext3 had been much much faster
>(on the order of 1s on ext4 vs 100ms on ext3).  There may be file system
>tuning parameters that can be tweaked to improve sync times.

Thanks for the infos. When using a transaction, it's done to about 2s.

The whole system lives on an SD card, where the root partition is
indeed formated in ext4:
===================
Disk /dev/mmcblk0: 3957 MB, 3957325824 bytes
4 heads, 16 sectors/track, 120768 cylinders, total 7729152 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x000332e9

        Device Boot      Start         End      Blocks   Id  System
/dev/mmcblk0p1   *        2048      440319      219136   83  Linux
/dev/mmcblk0p2          440320     7286783     3423232   83  Linux
/dev/mmcblk0p3         7288830     7727103      219137    5  Extended
/dev/mmcblk0p5         7288832     7727103      219136   82  Linux
swap / Solaris
===================
~# mount
sysfs on /sys type sysfs (rw,nosuid,nodev,noexec,relatime)
proc on /proc type proc (rw,nosuid,nodev,noexec,relatime)
udev on /dev type devtmpfs
(rw,relatime,size=10240k,nr_inodes=63463,mode=755)
devpts on /dev/pts type devpts
(rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000)
tmpfs on /run type tmpfs
(rw,nosuid,noexec,relatime,size=51516k,mode=755)
/dev/disk/by-uuid/b1767040-9366-43c0-9684-3a8ff83f6547 on / type ext4
(rw,relatime,errors=remount-ro,user_xattr,barrier=1,data=ordered)
tmpfs on /run/lock type tmpfs
(rw,nosuid,nodev,noexec,relatime,size=5120k)
tmpfs on /run/shm type tmpfs
(rw,nosuid,nodev,noexec,relatime,size=146840k)
/dev/mmcblk0p1 on /boot type ext2 (rw,relatime,errors=continue)
===================

I'll see if performance can be further improved.

Thanks all.