Hi, In our application we use sqlite with great satisfaction.
We currently benchmark our application and came up to a strange difference in creating a very simple sqlite db. We juste create a sigle table in a new db. In my docker container it take 4 time more time than in the host system. time sqlite3 /tmp/foo.db < f.sql on the host machine real 0m0.216s and in the docker container real 0m0.826s the f.sql contain a single sql CREATE TABLE f (fid VARCHAR, path VARCHAR, meta VARCHAR, mtime INTEGER, virtual INTEGER, pfid VARCHAR, type VARCHAR, ts INTEGER); I first think about a drive performance difference so i check the write thruput with dd and obtain nearly the same value. root@dipsy:/usr/share/kserver4# time dd if=/dev/zero of=/tmp/test bs=512 count=1024000 1024000+0 enregistrements lus 1024000+0 enregistrements écrits 524288000 octets (524 MB) copiés, 7,04168 s, 74,5 MB/s real 0m7.056s user 0m0.228s sys 0m2.688s in the container root@1e90b83b1b3f:/project# time dd if=/dev/zero of=/tmp/test bs=512 count=1024000 1024000+0 records in 1024000+0 records out 524288000 bytes (524 MB) copied, 6.79671 s, 77.1 MB/s real 0m6.977s user 0m0.272s sys 0m2.600s the filesystem is ext4 with data=ordered and /tmp is a volume mounted from the host in the [ docker -v /tmp:/tmp ] So my question is where can i investigate to see what happend ? Any idea or suggestion ? -- *Sébastien HEITZMANN* Gérant & Directeur technique +33 (0)3 89 333 889 Plus d'info sur : www.2le.net <http://www.facebook.com/pages/2le-Logiciel-libre-pour-lentreprise/194148499368?ref=ts> <http://twitter.com/2le_net#> <http://www.viadeo.com/profile/00225bbq5gc1ukcu> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
