After about an hour of continuous use on Vicidial, we are experiencing significant delays when using the soundboard, which affects the efficiency of our agents. What could be causing these delays, and how can we resolve the issue to ensure smooth operation throughout the day?
We were experiencing significant delays in the Vicidial soundboard after about an hour of continuous use. To resolve this, we modified the cron job responsible for flushing the queue DB table. Originally, the cron job was set to run only once every hour:
Before New Entry:
### flush queue DB table every hour for entries older than 1 hour
11 * * * * /usr/share/astguiclient/AST_flush_DBqueue.pl -q
We updated it to run every 15 minutes, flushing entries older than 10 minutes:
After New Entry:
### flush queue DB table every hour for entries older than 1 hour
#11 * * * * /usr/share/astguiclient/AST_flush_DBqueue.pl -q
11,26,41,56 * * * * /usr/share/astguiclient/AST_flush_DBqueue.pl –seconds=600 -q
After making this change, the issue with the soundboard delay was resolved. The more frequent flushing of the queue database prevents the buildup that was causing the delays.