[AdrianD]

Pretty straightforward question:

I want to remove certain npc_types from the DB I use, we'll call it live_db because I would make blanket changes to the main DB.

Is it better to delete the npc_types I want to remove or to change whether or not they spawn?

I understand the issues with sharing a spawngroupid. My concern is if there are continual queries searching for an npc that doesn't exist.

For expample, those filthy iksars:

use live_db;
delete from npc_types where race = 128; 

or

use live_db;
update spawnentry set chance = 0 select spawnentry.* from npc_types join spawnentry 
     where spawnentry.npcid = npc_types.id and npc_types.race = 128;

My application of this idea is a little different.

If there is an even more efficient way to do this, please divulge.