Logging

I have a database user in the system, and the logging is slow at times, the events appear in the log with some delay. Why? How can I fix this issue?

The proper indexing of the database solves this issue.

If the number of sent and received messages is high, the logging slows down due to the update processes during logging. If you index your database properly, the updates are faster resulting in faster logging. Check the 'Databases' tab of the 'Edit'/'Server preferences' window regarding indexing. Check the 'Received', 'Accepted for delivery', etc. tabs' 'where' conditions to find the proper variable to index your database.

What is the recommended database server for SQL logging?

We recommend Microsoft SQL Server.

It has a relatively bug free native OleDb driver, and a good implementation for storing large volume of data.

More information