SQLite performance on an ARM QNAP NAS

As part of my adventures I was looking into using a qnap NAS to run a small SQLite database I had. So I did some rudimentary benchmarking. The goal here is to scan millions of JPEG files on a QNAP NAS for comments and store the comments in SQLite.

Chip (ARMv7)

1
2
3
4
5
6
chip@chip:~$ time sqlite3 main <<< 'select count(time) from images;'
5980603

real 0m5.195s
user 0m4.340s
sys 0m0.850s

Linux laptop (Core2 Duo)

1
2
3
4
5
6
jay@x200:~$ time sqlite3 main <<< 'select count(time) from images;'
5980603

real 0m0.612s
user 0m0.472s
sys 0m0.108s

QNAP (ARMv5)

1
2
3
4
5
6
7
[/share/Public/scraped] # time sqlite3 main <<< 'select count(time) from images;'
5980603


real 0m38.980s
user 0m7.620s
sys 0m4.760s

Ok, it’s slow on the QNAP. This cannot be used as a database platform. The best we can hope for is sticking the CHiP to the side of it and mounting the QNAP filesystem over NFS.