We were trying to understand why we have so many queries being executed in our realtime database.
We identified a numerous query that was a little strange and now we are trying to understand why, possibly we are doing something wrong.
We verified that the res_odbc performs a select on the aors table for each of the connections that we originated in our application, obviously no aor is found, since the search is done by the dialed number @ ip address.
The aor is not found in the cache, the query is done in the database. We believe that this volume of queries may be affecting the performance of our environment as a whole, but we do not understand why.
A Dial string allows specifying an AOR to dial which would cause a query for a lookup. It likely doesn’t try to determine if it’s a URI first before doing so.