Quote:
Originally Posted by [GM]Dejo
Any more ideas?
|
Filter? Really?
Monitor your SQL, check your CPU/Disk usage, optimize your AddLogItem/AddLogChar procedures, if not using it already, use a SSD/nvme disk. Don't use SQL Express.
If anything queues up on SQL and can't get processed fast enough, it'll build up a delay on ShardManager.
For example, if quite some amount of characters are grinding, every few SP earned, GameServer will tell Shard to update the _Guild and _GuildMember tables with the earned GP Amount. If shard can't process those enough it will increase the latency.
Use your sql profiler and
[Only registered and activated users can see links. Click Here To Register...] might help too.