Quote:
Originally Posted by ffcmike
On a related note, at various times over the past week there's been some very abnormal serverside lag, where a Database NPC would be listed as 5 - 10% in RC /stats, which seems to be caused by SQLite queries immediately following eachother.
|
From experience I don't think this is caused by the SQL but rather by the server locking up (backups? other servers using too much memory?). On Era we often see scripts hit 10+% CPU when the server is lagging, even if the scripts aren't doing anything that should cause problems (e.g. doing damage to a player by changing their HP; no SQL or file I/O involved). Scripts using SQLite often are at the top of the CPU list at this time, but not always.
I'd like to see Stefan look into this and find the real problem, though. It's been around for years and affects big servers like Era and even small UC servers I've worked on with few scripts and one or two players online.