CPU Usage for requestsql

[Admins]

The displayed CPU usage is not very accurate when other processes run at the same time and slow down the machine. Most servers with playerworlds on them don't take a lot of CPU time though, it's often more about memory usage which leads to memory swapping if many servers use too much memory. It's always the first thing you should check when your npcserver is slow. Get rid of npcs with tons of variables, try to delete database npcs when you have more than 5000. You can also use "this.dontsave = true" and "this.savelocally = true" to reduce the number of npcs.

For optimizing SQLite I found the query "PRAGMA synchronous=OFF" very helpful, it's basicly not flushing the database to file each time you do an update. It should still be quite reliable.

[WhiteDragon]

Originally Posted by Stefan

The displayed CPU usage is not very accurate when other processes run at the same time and slow down the machine. Most servers with playerworlds on them don't take a lot of CPU time though, it's often more about memory usage which leads to memory swapping if many servers use too much memory. It's always the first thing you should check when your npcserver is slow. Get rid of npcs with tons of variables, try to delete database npcs when you have more than 5000. You can also use "this.dontsave = true" and "this.savelocally = true" to reduce the number of npcs.

For optimizing SQLite I found the query "PRAGMA synchronous=OFF" very helpful, it's basicly not flushing the database to file each time you do an update. It should still be quite reliable.

Do you think you could add "total memory" to /memstats ? That way we could tell if things are about to swap or not.

[Admins]

Originally Posted by WhiteDragon

Do you think you could add "total memory" to /memstats ? That way we could tell if things are about to swap or not.

It shows the memory the npcserver/gserver are currently allocating in /stats.

[WhiteDragon]

Originally Posted by Stefan

It shows the memory the npcserver/gserver are currently allocating in /stats.

Right but how much memory is available?