Quote:
Originally Posted by Mackx
TODO:
- Check influence of (many) thumbnails in the database
- Removing sorting from SQL-command to check if it is sorting or copying 'selected' data from database to memory that is consuming the time.
- Using OFFSET/LIMIT as a test to check impact.
|
I did some extra measurements (also on the emulator)
I removed the ORDER BY lines from the query
Book-View-no sort: 3022 books
load_dir_from_metadb() ~650ms
load_items_in_model() ~250ms
I added 'LIMIT 19 OFFSET 500' (to the original query with sorting)
Book-View-limit/offset: 3022 books
load_dir_from_metadb() ~1500ms
load_items_in_model() ~75ms
So as I already suspected the sorting takes most of the time. Using LIMIT/OFFSET does not give the speed gain hoped.
So I am afraid that 'simple' changes will not make the DR more responsive when using a lot of books.