I’m using xerial sqlite-jdbc library. When setting the mmap_size, I used the following
try (PreparedStatement pstmt =
conn.prepareStatement(
"pragma mmap_size=1000")) {
pstmt.execute();
}
However, this setting does not seem to persist when new connection is opened for the same database, though sqlite documentation says ” The mmap_size applies separately to each database file”.
What did I miss?