How to use sqlite pragmas - or how to set synchronize options?

[mifri...@gmail.com]

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