search

lemberg / connfa-android

Open Source Android app for Conferences and Events
http://connfa.com
Apache License 2.0
100 stars 111 forks source link

Adding indices on tables of local database for faster access. #19

Closed cdolar closed 7 years ago

cdolar commented 7 years ago

I experienced severe performance issues when switching between the days of a multi-day conference (3 to be precise). Environment was Android 5.1.1 on an LG Nexus 4. In the debugging console there was the hint, that the sqlite database is creating an auto-index each time there is a query on the database tables. Thus, I created a manual index on the tables.

TarasKunyk commented 7 years ago

Thanks for your update but we are going to replace SQL database in future so there is no point in SQL enhancements for now. P.S. Your pull request doesn't include corresponding code updates for new table (create_table_house_plans).