larrettp;303726 Wrote: > 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.
Hmmm m:m+RI... does not compute, Captain! Surely those m:m's have got to go (I know that means redesigning the tables/indexes/keys but even so...) Also - as I'm sure you know - RI only makes sense for 3rd+ normal form. Anyway, I'm sure you know exactly what you are doing! RI is really there (at least in this application) to cascade the deletes...but on a clear/re-scan you are in a database truncate situation... RI won't help you there. Also (unless I'm missing something) RI is used to enforce parent-child (1:m) integrity for inserts...I'm thinking manual data entry here). In a "batch" situation, you can force all the parents in first (sorry - starting to ramble now - it's been a long day at the office) -- 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
