[sqlite] Can autocommit create smaller files

2016-04-16 15:44 GMT+02:00 Cecil Westerhof : > When filling a table with 10.000 records the file is 501 KB without auto > commit and 500 KB with auto commit. Not a big difference, but I am > intrigued: can auto commit result in smaller SQLite files? > > Is with Java and SQLite 3.8.11. > ?It is

[sqlite] Can autocommit create smaller files

When filling a table with 10.000 records the file is 501 KB without auto commit and 500 KB with auto commit. Not a big difference, but I am intrigued: can auto commit result in smaller SQLite files? Is with Java and SQLite 3.8.11. -- Cecil Westerhof