Skip to content

Instantly share code, notes, and snippets.

@ecarnevale

ecarnevale/gist:106407

Created May 4, 2009 10:03
Show Gist options
  • Save ecarnevale/106407 to your computer and use it in GitHub Desktop.
Save ecarnevale/106407 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.m
// 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