Skip to content

Instantly share code, notes, and snippets.

@sync

sync/gist:106390

Created May 4, 2009 09:20
Show Gist options
  • Save sync/106390 to your computer and use it in GitHub Desktop.
Save sync/106390 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