Ben Sandee Wrote: > > FWIW, I made the same change on my system and didn't see any > improvement at > all (not that I was complaining about performance in the first place -- > I > wasn't). So YMMV. :-) > > Debian Sarge, Kernel 2.6.11, Athlon 800mhz, 512mb RAM, 1000 albums MP3 > >
Sure. 1000 albums means only around 15000 songs, so you should not expect much difference. docbee Wrote: > > I can hardly believe that slimserver does count all the titles, albums, > etc via sql and is not storing these values. The only way these values > could change is by doing a rescan, don't they? :-( > Maybe the difference between now and then really is the statistics info on the start page. Alas, the database table named "metainformation" cannot store the number of albums and artists, since there are only three columns: version, track_count and total_time So I guess this explains the full table scans for the stats... And from what I have learned from the source, there is only a generic parameterized function (find) to do any database find, including counting. That function does even discriminate between specific database features of MySQL and SQLite, BTW... -- meyergru _______________________________________________ Discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
