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