Hi,
Anyone else notice that sqlite3 in base got slower somewhat
recently?
I have a fairly large database, roughly 55M in size. I had to
repopulate it from source SQL file recently, and it took more
than twice the time I remember it taking with an older snapshot.
This is on "newer" snapshot[1]:
$ time sqlite3 the.db < in.sql
50m13.15s real 3m57.25s user 8m15.78s system
I remember this process taking something like 22m or so on the
same hardware. I am quite certain of that number, as I had to
do this quite often as I was developing the db.
To make sure I'm not way off base, I found another system with
the older snap and tested this. Granted, the hardware are
different, I think this slowdown is more due to software rather
than hardware: sqlite3 3.7.14.1 -> 3.7.17 possibly?
On older snapshot (different hardware)[2]:
$ time sqlite3 test.db < in.sql
14m51.17s real 0m57.85s user 2m34.72s system
I think it is reasonable to attribute the 15m vs 22m to the hardware
differences.
For reference, the input SQL starts off:
PRAGMA synchronous = OFF ;
PRAGMA foreign_keys = ON ;
Anyone else notice this slowdown?
--patrick
[1] "newer" snapshot.
newer=relatively speaking.
- netbook
- 4G ram
- cpu0: 1.6GHz
- sd0 scsibus0 targ 0 lun 0: <ATA, TOSHIBA MK2555GS, FG00> SCSI3 0/direct
$ sysctl kern.version
kern.version=OpenBSD 5.3-current (GENERIC.MP) #18: Sat Jul 6 16:54:29 MDT 2013
[email protected]:/usr/src/sys/arch/amd64/compile/GENERIC.MP
$ sqlite3 --version
3.7.17 OpenBSD
[2] older snapshot:
- desktop pc
- 512MB ram
- cpu0: 2GHz
- wd0 PIO mode 4, Ultra-DMA mode 5
$ sysctl kern.version
kern.version=OpenBSD 5.3-beta (GENERIC) #31: Tue Feb 12 16:24:39 MST 2013
[email protected]:/usr/src/sys/arch/amd64/compile/GENERIC
$ sqlite3 --version
3.7.14.1 OpenBSD
