Database cpu problem

[kaderebak]

dbo.item is using my cpu %100

What is the source of problem and how can ı fix that ?

[TRmuratTR]

Yeniden editle dbo.itemi

[TheSuperKiller]

cleanup items . by

DELETE FROM [Telecaster].[dbo].[Item]
WHERE owner_id=0

and also clear buffs .

DELETE FROM [Telecaster].[dbo].[State]

GO

[kaderebak]

if ı delete dbo.item players lose their items ?

[Cieldaron]

WHERE owner_id=0 means "only" items which aren't used and from the warehouse will be deleted.

It's your decision.

[kaderebak]

Originally Posted by Cieldaron

WHERE owner_id=0 means "only" items which aren't used and from the warehouse will be deleted.

It's your decision.

I'm sorry but I do not understand anything

Can you picture expression.

[Cieldaron]

DELETE FROM [Telecaster].[dbo].[Item]
WHERE owner_id=0

The part "WHERE owner_id=0" means that every item from the warehouse of every single player will be deleted as the database marks items which aren't in the inventory with owner_id = 0.

Got it now? (:

It also deletes items which aren't in use by any player (dropped items etc.).

[kaderebak]

Originally Posted by Cieldaron

DELETE FROM [Telecaster].[dbo].[Item]
WHERE owner_id=0

The part "WHERE owner_id=0" means that every item from the warehouse of every single player will be deleted as the database marks items which aren't in the inventory with owner_id = 0.

Got it now? (:

It also deletes items which aren't in use by any player (dropped items etc.).

Is not this just a temporary solution ?

[Cieldaron]

I didn't suggest it.

I just wanted to clarify that this query will probably delete everything from your warehouse.

[RoflcopterGoesSoiSoiSoi]

It's been a while since I looked in the database, but I'm pretty sure it deletes some auction-related information. I forget how the AH works, but I swear I remember it setting owner_id to 0.

This will horribly destroy your database if tamed creatures are inside the warehouse.