Phil Leigh;303723 Wrote: > Hi there - please ignore my comment about playlists as I don't use > them...but I do design very large (>10Tb) commercial databases for a > living! > > (OK so they don't use MySQL...but the general principles tend to > apply!) > > That "cascade on delete" looks worrying :o) - also, what are these m:m > relationships? - they tend to not work at all! (I'm a third-normal form > type of guy :o) )
I'm a Mainframe DBA, so that's how my interest in this came about. I must admit, I'd never touched MySQL until today but, as you say, the same principles apply. The thing about this whole design that gets me is the use of the many-to-many's - especially with the RI turned on so aggressively. I'll keep you posted about any results. Currently, in the absence of any programme information but based solely on the SQL logs, I've removed the RI and Indexed the affected tables up to the eyeballs! The initial results are encouraging, despite the slightly less han scientific methodology. -- 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
