mherger Wrote:
> >
> There's an optimisation in DBIStore.pm around page 325:
> # Optimize the all case
> if (scalar(keys %findCriteria) == 0) {
>
> I don't know how much this would speed up the count. But it's rarely
> used
> as Pages.pm adds the contributor.role to %findCriteria even if it's
> undefined.
>
> ...
>
> There's little impact with my test notebook's 500 songs, though...
>
That might save the full table scan for calculating song_count, but the
scans for album_count and artist_count are still being done, so may this
is why you don't see much improvement from that correction.
The file DBIStore.pm seems to be the right place to store the global
values, since that is where this optimization is done (as you found,
incorrectly) for song_count (aka trackCount). They need not even be in
the metainformation table, a global variable as in my hack should
suffice.
Whatever, that's all up to Dan Sully... I'm out now.
--
meyergru
_______________________________________________
Discuss mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/discuss
