JJZolx;303532 Wrote: > Current playlists are stored in the database. So when you add a > playlist of 7500 tracks then you're doing 7500 table INSERTs. The time > taken is always going to be directly proportional to the size of the > playlist. > > Not to mention that if you're shuffling the playlist then it's all > being done in memory on a server platform that can barely get out of > its own way. There was a post a while back from someone at Infrant (I > may actually have read it in the Infrant forums) explaining why. When > SlimServer 6.0 came out, with its move to MySQL for its dbms, it was > faster on many systems with large libraries, slower on some systems > with small libraries, but very much slower on the ReadyNAS. It was > explained by Infrant that the ReadyNAS CPU architecture was uniquely > unsuited to running MySQL.
7,500 inserts on an indexed table on a PC might take a while... On the other hand, all main queries need to be index-covered so you only read the index, not the data, wherever possible. There is a read/write trade-off here, but since a database is (usually) write once, read many times, its best to invest the performance in the read rather than the write (at least in this application - unlike say a shopping cart, or airline system...) I get annoyed by the length of time a scan takes (even with 7.x which is much faster than before)...but actually its the read performance that drives the user experience. I don't get why it takes 60 mins to do 30k updates. I can't help wondering if the old trick of dropping all indexes, rescanning and then re-adding the indexes back at the end (obviously only for a clear & rescan!) would improve matters. Doing updates to a table with a physically-clustered index is always slow... Also, is it just me (I don't use playlists at all) but isn't 7.5k a bit BIG for a playlist? -- Phil Leigh You want to see the signal path BEFORE it gets onto a CD/vinyl...it ain't what you'd call minimal...SB3+Stontronics PSU - Altmann JISCO/UPCI - TACT RCS 2.2X with Good Vibrations S/W - MF X-DAC V3/X-PSU/X-10 buffer (Audiocomm full mods)- Linn 5103 - Linn Aktiv 5.1 system (6x LK140's, ESPEK/TRIKAN/KATAN/SEIZMIK 10.5), Townsend Supertweeters, Kimber & Chord cables ------------------------------------------------------------------------ Phil Leigh's Profile: http://forums.slimdevices.com/member.php?userid=85 View this thread: http://forums.slimdevices.com/showthread.php?t=45261 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
