List:General Discussion« Previous MessageNext Message »
From:Junior Ortis Date:January 15 2010 5:01am
Subject:Better that `NOT IN`
View as plain text  
Hi guys i have a problem, 3 big tables: item_instance about 15KK rows,
character_inventory 15KK rows, guild_bank_item 2KK rows.

And i need i clean on item_instance how this query:

DELETE FROM `item_instance` WHERE guid NOT IN(SELECT item FROM
`character_inventory`) AND guid NOT IN(SELECT item_guid FROM
`guild_bank_item`) AND
guid NOT IN(SELECT item_guid FROM `mail_items`) and guid NOT IN(SELECT
itemguid FROM `auctionhouse`);

Well atm is running about 13 hours, State = Sending Data.

I will be a better option ?

Thanks all !
Better that `NOT IN`Junior Ortis15 Jan
  • Re: Better that `NOT IN`Peter Brawley15 Jan
    • RE: Better that `NOT IN`Daevid Vincent15 Jan
      • Re: Better that `NOT IN`Dan Nelson15 Jan
  • Re: Better that `NOT IN`fsb15 Jan