item_instance data to normal fields:

[voidx]

I think it would be good to move the data field of item_instance to normal table fields and discart more redundant information.

Wath do you think about this?

[bisonte]

I agree with this idea

[Toinan67]

Well I think we all agree with this idea, this was already done for the data field of characters table.

But atm I don't know if all that stuff in item_instance.data can be stored somewhere else or deleted.

Maybe it's on devs' todo-list ?

[nanounico]

that would be great!

[voidx]

Item_instance and querys like

SELECT data,text,bag,slot,item,item_template FROM character_inventory JOIN item_instance ON character_inventory.item = item_instance.guid WHERE character_inventory.guid = '%u' ORDER BY bag,slot;

cause unnecessary delays.