When the chat goes too fast (spam) Naoko has trouble writing each line to its sqlite database. It uses up a lot of disk and CPU, until it can no longer catch up and times out to the server.
Chat logging could be limited to at most once every second. When there is more than one line in a second, multiple lines will be cached and wait to be inserted in one transaction. In the event of a crash, the most data loss that will happen (because of this change) is one second of chat.
When the chat goes too fast (spam) Naoko has trouble writing each line to its sqlite database. It uses up a lot of disk and CPU, until it can no longer catch up and times out to the server.
Chat logging could be limited to at most once every second. When there is more than one line in a second, multiple lines will be cached and wait to be inserted in one transaction. In the event of a crash, the most data loss that will happen (because of this change) is one second of chat.