Skip to content

Instantly share code, notes, and snippets.

@luisdelarosa
Created May 6, 2009 21:25
Show Gist options
  • Save luisdelarosa/107753 to your computer and use it in GitHub Desktop.
Save luisdelarosa/107753 to your computer and use it in GitHub Desktop.
// This sqlite3_exec limits the database to 50 DB pages (about 1.5Kb each)
// Huge memory win on iPhone.
if(sqlite3_exec(myDatabsae, "PRAGMA CACHE_SIZE=50", NULL, NULL, NULL) != SQLITE_OK)
NSLog(@"Couldn't set cache size: %s", sqlite3_errmsg([self.database sql]));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment