[asterisk-users] ODBC Voicemail and performance....

[Tony Plack]

Running on branch/1.4

I have been watching some the queries from Asterisk and I think I have a place where some efficiency can come, but I am at a lost as to what is calling it...

It appears that every 10-15 seconds, every mailbox INBOX and Old gets queried for the number of voice mail files.

I have exposed SIP to verify that it wasn't the phones requesting.

It is not much of a problem in a small voice mail system, but if there are 500 mailboxes, that is over 1000 queries per event and if it is occurring every 15 seconds that is 4000 queries a minute just to see if the voice mail has change.

So I would like to change this, just not sure where to look.  It seems to me we only need to query this when we call the VM app or a user enters the VM system.  That does leave a problem for outside changes via the database on clustered systems, but...  I believe there is a way around that where we could have 1 query every defined number of seconds.

Just need to know how to find out what is polling that function.