Phil Leigh;303714 Wrote: > 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?
I totally agree with all that you say about the Read/Write tradeoff. I've downloaded MySQL to my Mac and I'm currently experimenting with a few interesting combinations. I also found that the many-to-many records have Foreign Keys (with CASCADE ON DELETE) on them, which could be affecting things. I realise that this is a case of making the database fit the code - which is the wrong way round - but I don't want to instigate any code changes at the moment until I've proved the principle. As for the size of my playlists, there shouldn't be a limit on such things (iTunes doesn't have one and it handles them instantly). I just have very eclectic taste and I enjoy the element of surprise! More news later when I've finished the tests I'm currently running. -- larrettp ------------------------------------------------------------------------ larrettp's Profile: http://forums.slimdevices.com/member.php?userid=10191 View this thread: http://forums.slimdevices.com/showthread.php?t=45261 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
