CODEWITHSUNDEEP
objective-cios4sqlitexcode4.3
jothikenpachi
jothikenpachi

Reputation: 656

Sqlite3 Fetching takes More time in iphone

While I fetching data from sqlite3 using some JOINS and Group by Conditions, it takes More Time.

The table has 30000 records

Is There Any optimising Way To Fetch Large Junk of Data from SQlite?

Upvotes: 0

Views: 144

Answers (1)

HeadNinja
HeadNinja

Reputation: 69

You can limit sqlite to return only the top n results and offset by m to get the later entries as your user scrolls down: SELECT someColumn ORDER BY someOtherColumn LIMIT n OFFSET m

This would be much more efficient. Should I elaborate more?

Upvotes: 1

Related Questions