All my other tests give me some equivalent time in host and in container. I have reduced the problem to the creation of the database. The rest of my workload run approximatively in the same time.
You're right, there is some variance between each test but the 4 factor stay the same. Sometime it's 180ms , sometime 240ms on the host. But on the container it is always around 800ms. I also use pysqlite with the same result. I'm currently test the disk access with bonnie++ to see if any filesystem or disk setting could be implied. SEB 2017-11-30 12:48 GMT+01:00 Olivier Mascia <o...@integral.be>: > > Le 30 nov. 2017 à 12:00, Sebastien HEITZMANN <2...@2le.net> a écrit : > > > > 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 > > Couldn't it be a discrepancy in the way 'time' measures on the host or > through the container? > Or simply a difference in speed of code execution through the container? > Instead of an actual difference of behaviour/performance of SQLite itself? > > The test (creation of this small db) is so small that timing it has a > large potential for variance due to the system itself. > > -- > Best Regards, Meilleures salutations, Met vriendelijke groeten, > Olivier Mascia > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- *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
