Loot Lag

[image]

Clients are all processed in a single loop (client 1, client 2, client 3, loop back) and database calls are synchronous so client 1 can be stuck writing to DB and client 1,2,3 all hang on their network process.

I still suggest the issue could be database related or you have a really terrible network (or maybe both). If the database is on a remote server other than what the zone server is running on that potentially is also a problem.

[provocating]

Yeah what Image just said.

I remember something quirky going on about 7 months ago on Chronicles of Norrath. I experienced something similar but not while looting, just opening up a vendor. Since those processes are in the same processing loop one person could open up a vendor and stall the rest out. As soon as you right click on a merchant a select statement is run. I seem to remember just dropping my database, creating a new one and importing it back in solved the problem.