Perhaps the file sync performed by SQLite is more expensive in the docker environment than in the host. That would make sense to me.
On Nov 30, 2017 7:07 AM, "Sebastien HEITZMANN" <2...@2le.net> wrote: > In my last mail i have multiple table creation and index. It seam that the > overtime is for all the create statement. > > It really looks like a disk pb. But can't identify so much difference in my > direct disk access ( with DD ) > > I will try it on an other host. > > 2017-11-30 14:59 GMT+01:00 Simon Slavin <slav...@bigfraud.org>: > > > OP wrote: > > > > > CREATE TABLE f (fid VARCHAR, path VARCHAR, meta VARCHAR, mtime INTEGER, > > > virtual INTEGER, pfid VARCHAR, type VARCHAR, ts INTEGER); > > > > Is this the first content of a new file ? If so, SQLite has to create > the > > file and write some structure information as well as writing the table. > I > > suspect that the time taken for the overhead is far more than the time > > taken for the CREATE command. > > > > Could you try changing f.sql to create ten tables ? For example create > > the table "f1 as above then create tables "f2" to "f1" with the same > > columns ? It would be interesting to see what this does to both timings. > > > > Simon. > > > > _______________________________________________ > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
