I did a couple of experiments with the CB menu items based on custom scan data and similar to 'works for composer' listed in a previous post.
Right after a full Custom Scan rescan they are all quick, memory usage around 290M. When I restarted the next day, the memory usage of the server was much lower (around 186M). The first run of each menu based on Custom Scan took a minute or two. Once run, the menu is quick again. Having run most of my menu items memory usage was up again to around 218M. Later that day, after several hibernate/restarts, memory before hibernating was 183M, and after restart was 152M. Menus based on custom scan data were, once again, slow, although not as slow as after a full shutdown and restart. Memory usage rose to over 155M after running each menu. I have now (today) had to turn off all auto rescan and refresh features of custom scan since they made my PC's performance become very erratic. I'm still a bit unclear what 'refresh' does (as opposed to rescan), but turning it off seems to help general performance. One hypothesis is that hibernating and restarting a PC loses some form of in-memory cache of SQLite data for menus based on custom scan data, which did not seem to happen in SB 7.5.n based on Mysql. However, I have to say the marginal increase in memory usage after my last hibernate/restart did not seem that large. For info: persist.db is 238MB, persist.db-shm is 32K and persist.db-wal is 86K. library.db is 34MB, library.db-shm is 32K and library.db-wal is 430K. In persist.db, my customscan_track_attributes has 257K rows (customscan_album.. & ..contributor are empty). I could extract other data if useful, or get some extra log data. I never had performance issues with menus on mysql, but I did have some issues with the scanning time. 7.6.1 is much quicker scanning, both SB basic and Custom Scan, which is a great improvement. And to reiterate the problem of this thread, when a CB menu based on custom scan is slow, it can be so slow that the Touch loses contact with the server and any track playing stops (not straight away, but after 30 seconds to a minute or so). -- PasTim Server on Windows 7 Ultimate 64 bit, 2 CPU, 2GHz, 4GB, FLAC files. Touch on Ethernet (in another room). Analogue out over 'a bit of wire' to ageing Quad Hi-Fi. An old (wireless) laptop controls the server using Chrome. ------------------------------------------------------------------------ PasTim's Profile: http://forums.slimdevices.com/member.php?userid=41642 View this thread: http://forums.slimdevices.com/showthread.php?t=90112 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
