samedi 28 mars 2015

SQLite. How to populate ListView partially?

I am trying to populate ListView from SQLite database. I am using this query to get needed data from database:



SELECT rowid AS _id, value, entries
FROM meaning
WHERE key
LIKE 'dog%'
ORDER BY key
LIMIT 100


Result is coming in 510ms. This is quite slow for incremental search. Is it possible to populate ListView part by part so that when user scrolls down ListView, other part of data will be shown?


Aucun commentaire:

Enregistrer un commentaire