CODEWITHSUNDEEP
iphonesqliteperformance
georgij
georgij

Reputation: 2200

Slow SQLite access on iPhone

I have a quite slow data retrieval from a sqlite database on my iPhone and perhaps someone have an alternative idea to explain this. From what I tracked down so far sqlite3_step(statement) is sometimes unusually slow. While retrieving e.g. 50 rows from the database to execute this step takes normally some milliseconds but sometimes it takes several seconds.

My database is not small (80MB) and my theory is that the reason is paging. But can someone else think of an other reason for this?

Upvotes: 1

Views: 2027

Answers (1)

Zoran Simic
Zoran Simic

Reputation: 10333

Do you have a proper index on that table? Queries can be very slow if a full table scan is required to perform your query. See this page for example for some guidance on how to optimize your SQLite queries.

You may simply need to add an index to your table. Don't forget to reindex your table after you add your index (you'll need a tool, there's a free firefox add-on called "SQLite Manager" that does a pretty decent job for this)

Upvotes: 2

Related Questions