Dominique Devienne wrote: > In JOURNAL mode, new data goes to DB file directly, and modified pages go to > the JOURNAL file. > And since here this is INSERT-only, from empty tables, I assumed pages copied > to the JOURNAL > file should be minimal.
Yes. You can check the journal size with PRAGMA journal_mode = PERSIST. > ... --blobs-as-hdf5=false --blobs-inline=false > Write ROWs = 4.358s (12.6%) > Write BLOBs = 3.130s ( 9.0%) > Epilog = 10.221s (29.5%) > > ... --blobs-as-hdf5=true --blobs-inline=false > Write ROWs = 4.368s (17.0%) > Write BLOBs = 4.179s (16.3%) > Epilog = 0.461s ( 1.8%) This looks as if HDF5 does not do fsync(). Compare with PRAGMA synchronous = OFF, or run https://docs.microsoft.com/en-us/sysinternals/downloads/sync after you've finished with the HDF5 file. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
