Using foreign keys and cascades

sesmar · #7 11-11-2006, 01:53 PM

Quote:

Originally Posted by Rhodan

I got 231 orphaned records in the ax_peq18d database.

That is not that bad. Where you really want to look is the Spawn Groups.

Code:

SELECT
  spawngroup.id,
  spawnentry.spawngroupID,
  spawnentry.npcID,
  npc_types.name
FROM
  spawnentry
  LEFT JOIN spawngroup
    ON spawngroup.id = spawnentry.spawngroupID
  LEFT JOIN npc_types
    ON npc_types.id = spawnentry.npcID
WHERE
  spawngroup.id IS NULL
ORDER BY
  npc_types.name

4187 Records. And if you also look at the number of them that have a null NPC ID as well. That is more surprising.

Some other things that I have been looking into to help increase performance is Indexing; however, the current indexing seems to be what is needed.