protected void RunDefaultInitialization(IDatabaseConnection db)
{
var queries = new List <string>
{
"PRAGMA journal_mode=WAL",
"PRAGMA page_size=4096",
"PRAGMA synchronous=Normal"
};
if (EnableTempStoreMemory)
{
queries.AddRange(new List <string>
{
"pragma default_temp_store = memory",
"pragma temp_store = memory"
});
}
else
{
queries.AddRange(new List <string>
{
"pragma temp_store = file"
});
}
db.ExecuteAll(string.Join(";", queries.ToArray()));
}
public static void RunQueries(this IDatabaseConnection db, string[] queries)
{
db.BeginTransaction(TransactionMode.Deferred);
try
{
db.ExecuteAll(string.Join(";", queries));
db.CommitTransaction();
}
catch (Exception)
{
db.RollbackTransaction();
throw;
}
}
