internal BansheeDbConnection(string db_path) : base(db_path)
{
// Each cache page is about 1.5K, so 32768 pages = 49152K = 48M
int cache_size = (TableExists("CoreTracks") && Query <long> ("SELECT COUNT(*) FROM CoreTracks") > 10000) ? 32768 : 16384;
Execute("PRAGMA cache_size = ?", cache_size);
Execute("PRAGMA synchronous = OFF");
Execute("PRAGMA temp_store = MEMORY");
// TODO didn't want this on b/c smart playlists used to rely on it, but
// now they shouldn't b/c we have smart custom functions we use for sorting/searching.
// See BGO #603665 for discussion about turning this back on.
//Execute ("PRAGMA case_sensitive_like=ON");
Log.DebugFormat("Opened SQLite (version {1}) connection to {0}", db_path, ServerVersion);
migrator = new BansheeDbFormatMigrator(this);
configuration = new DatabaseConfigurationClient(this);
if (ApplicationContext.CommandLine.Contains("debug-sql"))
{
Hyena.Data.Sqlite.HyenaSqliteCommand.LogAll = true;
WarnIfCalledFromThread = ThreadAssist.MainThread;
}
}
internal BansheeDbConnection (string db_path) : base (db_path)
{
// Each cache page is about 1.5K, so 32768 pages = 49152K = 48M
int cache_size = (TableExists ("CoreTracks") && Query<long> ("SELECT COUNT(*) FROM CoreTracks") > 10000) ? 32768 : 16384;
Execute ("PRAGMA cache_size = ?", cache_size);
Execute ("PRAGMA synchronous = OFF");
Execute ("PRAGMA temp_store = MEMORY");
// TODO didn't want this on b/c smart playlists used to rely on it, but
// now they shouldn't b/c we have smart custom functions we use for sorting/searching.
// See BGO #603665 for discussion about turning this back on.
//Execute ("PRAGMA case_sensitive_like=ON");
Log.DebugFormat ("Opened SQLite (version {1}) connection to {0}", db_path, ServerVersion);
migrator = new BansheeDbFormatMigrator (this);
configuration = new DatabaseConfigurationClient (this);
if (ApplicationContext.CommandLine.Contains ("debug-sql")) {
Hyena.Data.Sqlite.HyenaSqliteCommand.LogAll = true;
WarnIfCalledFromThread = ThreadAssist.MainThread;
}
}
public BansheeDbConnection() : base(DatabaseFile)
{
// Each cache page is about 1.5K, so 32768 pages = 49152K = 48M
int cache_size = (TableExists("CoreTracks") && Query <long> ("SELECT COUNT(*) FROM CoreTracks") > 10000) ? 32768 : 16384;
Execute("PRAGMA cache_size = ?", cache_size);
Execute("PRAGMA synchronous = OFF");
Execute("PRAGMA temp_store = MEMORY");
Execute("PRAGMA count_changes = OFF");
// don't want this on because it breaks searching/smart playlists. See BGO #526371
//Execute ("PRAGMA case_sensitive_like=ON");
Log.DebugFormat("Opened SQLite connection to {0}", DatabaseFile);
migrator = new BansheeDbFormatMigrator(this);
configuration = new DatabaseConfigurationClient(this);
if (Banshee.Base.ApplicationContext.CommandLine.Contains("debug-sql"))
{
Hyena.Data.Sqlite.HyenaSqliteCommand.LogAll = true;
WarnIfCalledFromThread = Banshee.Base.ThreadAssist.MainThread;
}
}