I am developing an Android app that works with an SQLite database locally. I am wondering what the best way is to load data from the database.
the database would contain about 3 tables that would total up to about 500 rows. What would be the best option in this case:
- Load all data on startup to fill the java model for use in the application.
- Load only data that is needed in each screen. This probably requires db calls on nearly each screen load but will need less memory. If this is the best solution, how do you handle this situation ? If you would open a view, you would have to query the db since not everything is pre-loaded. But if you would open it again afterwards, you would have to have some kind of 'caching' mechanism to detect if it's already pre-loaded?
desertnaut
60.8k32 gold badges155 silver badges183 bronze badges
asked Sep 26, 2013 at 14:56
Wesley
1,0193 gold badges12 silver badges19 bronze badges
-
2stackoverflow.com/questions/371538/…degratnik– degratnik2013年09月26日 15:00:52 +00:00Commented Sep 26, 2013 at 15:00
-
mix both. use an LRU cache with your database.njzk2– njzk22013年09月26日 15:25:05 +00:00Commented Sep 26, 2013 at 15:25
1 Answer 1
What would you do if your database grew to 5,000 rows? 50,000?
Premature optimization is one of the leading causes of poor design. In my (relatively limited) experience, SQLite database queries are fast enough. Try loading your data on demand, as is fairly standard practice, and see if your program runs quickly enough.
answered Sep 26, 2013 at 15:01
Dan Breslau
11.6k2 gold badges38 silver badges44 bronze badges
Sign up to request clarification or add additional context in comments.
Comments
lang-sql