/// <summary>
/// SQLite 성능을 높히기 위해, PRAGMA 설정을 수행합니다.<br />
/// 참조 : http://www.sqlite.org/pragma.html
/// </summary>
/// <param name="db"></param>
/// <param name="connection"></param>
internal static void SetPragma(this SQLiteDatabase db, SQLiteConnection connection) {
connection.ShouldNotBeNull("connection");
if(IsDebugEnabled)
log.Debug("SQLite DB에 PRAMA 설정을 수행합니다... PRAGMA 설정=[{0}]", PragmaSettings);
try {
//using(var cmd = new SQLiteCommand(PragmaSettings, connection))
// cmd.ExecuteNonQuery();
new SQLiteCommand(PragmaSettings, connection).ExecuteNonQuery();
}
catch(Exception ex) {
if(log.IsWarnEnabled)
log.WarnException("PRAGMA 설정 시에 예외가 발생했습니다. 무시합니다.", ex);
}
}