View Single Post
Old 09-17-2014, 03:36 AM   #39
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,509
Karma: 8065348
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by kaufman View Post
As an experiment, I turned off the "show counts" and my system is running a lot faster. Since the counts do not change while you are disconnected, would it be possible to cache the counts at disconnect and not calculate them each time you open a subgroup. On a large library, it makes a big difference.

Edit: or even better. Instead of caching them at disconnect, cache then the first time each group is selected after a disconnect. It's a smaller wait, and if they don't select a group, you never have to calculate for that group.
Can't do this. The counts change because of searches/long presses.

I will look at whether I can improve the queries.
chaley is offline   Reply With Quote