Hi,
I would like to use ormlite+sqlite on Linux Unluckily, sqlite is very slow in terms of write performance until someone disables synchronize.
If I unterstood it right, this needs to happen on a connection-base. Even if I try to do something like
DatabaseConnection dc = connectionSource.getReadWriteConnection();
dc.setAutoCommit(false);
dc.executeStatement("PRAGMA synchronous = NORMAL",
DatabaseConnection.DEFAULT_RESULT_FLAGS);
dc.executeStatement("PRAGMA journal_mode = TRUNCATE",
DatabaseConnection.DEFAULT_RESULT_FLAGS);
dc.executeStatement("PRAGMA page_size = 4096",
DatabaseConnection.DEFAULT_RESULT_FLAGS);
it bails out saying it is still on a transaction or it can't be changed while in a transaction (depends whether auto commit is off or on)
So - how do I archive this?
Best regards,
Michael Fritscher