[asterisk-users] odbc question

Giedrius Augys voipas at gmail.com
Fri Jan 22 01:49:13 CST 2010


2010/1/21 Tilghman Lesher <tlesher at digium.com>

> On Thursday 21 January 2010 09:51:13 Giedrius Augys wrote:
> > Is it possible to free idle connections? When limit was 40, I had lost
> part
> > of data. My asterisk version is 1.6.0.20 .
>
> We intentionally do not, since the maximum number of connections is always
> the maximum concurrent number of queries, and there's a significant penalty
> in establishing a connection.
>
> --
> Tilghman Lesher
> Digium, Inc. | Senior Software Developer
> twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
> Check us out at: www.digium.com & www.asterisk.org
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>



Yes, I'm using FreeTDS. In Asterisk Console I can see 200 SET command (for
inserting to MSSQL: Set("Local/123456789 at from-trunk-2f45;2",
"ODBC_INSERT_RECORD()=111111,123456789")), but in MS SQL I can see only 60
or 43 records. Maybe it's possible wait some time , if all connections are
busy and retry again insert records?
-- 
Pagarbiai  / Best Regards,
Giedrius
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100122/bd1a7be1/attachment.htm 


More information about the asterisk-users mailing list