Philip Meyer;649007 Wrote: > >I suspect the reason JJZolx sees bigger difference between 7.5.6 and > >7.6.1 is because he uses a more optimized MySQL configuration then > the > >one selected with "High" in SBS Settings/Advanced/Performance which I > >used. Or it could be related to that he used a later MySQL version > than > >5.0.21 which is distributed with SBS or that he is using Windows, but > I > >suspect it's related to the MySQL configuration which makes MySQL > scale > >better in larger libraries. > > Or could it be some virus/firewall detection software slowing it down > on your machine?
Nope. I'm wondering if it could be tagging related, since I tag every track with both an ALBUMARTIST and ARTIST. This could lead to twice as many db lookups for contributors as others' libraries, which looks like it may be a problem for SQLite using WAL. > > PERFORMANCE CONSIDERATIONS > > Write transactions are very fast since they only involve writing the > content once (versus twice for rollback-journal transactions) and > because the writes are all sequential. Further, syncing the content to > the disk is not required, as long as the application is willing to > sacrifice durability following a power loss or hard reboot. (Writers > sync the WAL on every transaction commit if PRAGMA synchronous is set > to FULL but omit this sync if PRAGMA synchronous is set to NORMAL.) > > *On the other hand, read performance deteriorates as the WAL file grows > in size since each reader must check the WAL file for the content and > the time needed to check the WAL file is proportional to the size of > the WAL file.* The wal-index helps find content in the WAL file much > faster, but performance still falls off with increasing WAL file size. > Hence, to maintain good read performance it is important to keep the > WAL file size down by running checkpoints at regular intervals. http://www.sqlite.org/wal.html Need more checkpoints? -- JJZolx ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=89513 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
