I use a huge database in my iPhone application to make the search faster in this database, An index is used on a column. The problem is that this index increases the size of the database: My application is now larger than 20M in which WIFI download is required (below allowable for 3G download permission Have to stay).
As a result, to reduce the size of this database, when I first launch the application, I want to index the user on the iPhone.
The SQLite query I want to execute is the following:
"Create MY_TABLE (MYCOLUMN) on IDE INDEX_ON_MYCOLUMN"
Do you know how it is included Query in my XCode code? Sqlite3_something?
By the way, how do the programmatic database compact after this operation?
Thank you very much for your help!
sqlite3_exec () Perhaps what you want to do. You can run it on every launch rather than just the first launch (extra time will fail only in harmless way). Of course, your launch time can be awesome.
See also vacuum analysis .
Comments
Post a Comment