CMDHELPER-2699 - Reported by Josh.vdub

Here are some timings reports from my server. Right now I do have scripts, but I got the same results during a period that I checked with no scripts at all installed

skyblock server: right after server start: http://aikar.co/timings.php?url=5732661

skyblock server: a bit in: http://aikar.co/timings.php?url=5732681

minigames server: since start http://aikar.co/timings.php?url=5733136

skygrid server: since start http://aikar.co/timings.php?url=5733142

survival server: http://aikar.co/timings.php?url=5733144 there is only one script on this server which is /randomspawn and probably hasnt even been used since server start, yet you can still see usage from commandhelper on player command event

spigot thread I posted: http://www.spigotmc.org/threads/spigot-commandhelper-player-command-events.2500/

Comment by PseudoKnight

Could you clarify this: "I got the same results during a period that I checked with no scripts at all installed". It seems you're suggesting that a clean install of CH has a 160-330ms overhead on your server for command events. Is that right?

Comment by Josh.vdub

yes, I started removing command one by one to see which command was causing the lag nothing fixed it so I deleted all the commands, as well as the auto_include and main.ms file and nothing changed in the timings report it had the same lag. It also seems to scale with the amount of players online, since the survival server only had about 5 people on and the skygrid server had over 100 when I tested

Comment by LadyCailin

After looking into this issue, it was discovered that the problem is with this user's sqlite db has 5 million rows in it (and is 13MB). I'm closing this bug, but will continue to work to get his server configured with a better DB backend.