[Date Prev][Date Next][Thread Prev][Thread Next]
[Date Index]
[Thread Index]
- Subject: Re: [SQLite] Use of db:exec cause 5 second delay
- From: Gilles Ganault <gilles.ganault@...>
- Date: Thu, 30 Jan 2014 00:45:32 +0100
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.