03-05-2014 12:07 PM
We have a performance issue with our sqlite database.
There are about 10k entries in the table. We select 20 of them with a trivial query (select * by id1 and id2 order by date desc limit 20 offset 0) within a transaction.
The device needs 865ms for this, when we copy the database to the PC and use SQLiteManager the call is executed in 76ms.
As we can get tables with about 100k entries in some cases we would really like to get these queries faster.
Solved! Go to Solution.
03-05-2014 12:22 PM
03-06-2014 07:43 AM - edited 03-06-2014 10:19 AM
edit: solved it
it is quite bothersome to optimize the indices as the bb10 sqlite is prone to using a different approach than the SQLiteManager.
Still, we have several working indices now, an "ANALYZE" at the end of the initialization also improved the performance, and on top we have added some limitations to the queried range.
we also loaded a list of often-used things into memory at app launch.