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
- Bases du SMS
- Pourquoi le SMS est-il si réussi ?
- Exemples d'applications de messagerie SMS
- Formats de numéros SMS
- Types de messages SMS et MMS
- Centre de service de messages courts (SMSC)
- Passerelle SMS
- Système SMS bidirectionnel - Ozeki NG
- Exigences matérielles et logicielles
- 2.2 Exigences réseau
- Passerelle SMS Ozeki - Informations générales sur le logiciel
- Routage
- Types de messages
- Rapports de livraison
- Modem GSM
- SMPP
- CIMD2
- UCP/EMI
- HTTP
- SMTP
- API
- SQL vers SMS
- Passerelle HTTP vers SMS
- Transfert d'e-mail vers SMS et SMS vers e-mail
- Base de données de réponses automatiques
- Performance et évolutivité
- Journalisation
- Résolution de problèmes
- Contrôle des coûts et statistiques d'utilisation
- Version d'essai de la passerelle SMS
- Questions commerciales