[asterisk-users] Concurrent calls including mysql taking lot oftime for execution

[Tilghman Lesher]

On Wednesday 21 October 2009 15:16:31 Jeff LaCoursiere wrote:
> On Wed, 21 Oct 2009, Danny Nicholas wrote:
> > Not my cup of tea, but I think I'd be trying an ODBC connection to reduce
> > some overhead here.
>
> [snip]
>
> Does that reduce overhead or add it?  Seems that direct mysql-client code
> should be more efficient than adding ODBC in the middle...

In this case, it would reduce overhead.  The example he provides creates a
unique connection for every channel, which is massive overkill for MySQL.
Only Sybase and MS SQL Server require a distinct connection for each live
query.  MySQL can very effectively run multiple queries on a single
connection.

-- 
Tilghman Lesher
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com & www.asterisk.org