On Friday 22 January 2010 09:53:33 Giedrius Augys wrote: > 2010/1/22 Tilghman Lesher <tles...@digium.com> > > > On Friday 22 January 2010 01:49:13 Giedrius Augys wrote: > > > 2010/1/21 Tilghman Lesher wrote: > > > > 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. > > > > > > Yes, I'm using FreeTDS. In Asterisk Console I can see 200 SET command > > > > (for > > > > > inserting to MSSQL: Set("Local/123456...@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? > > > > Are you getting an error or a warning? We cannot begin to guess at what > > might > > be wrong without seeing more information. > > No errors and warnings! If you need, I can make a test again.
My guess is that there's actually nothing wrong, then, and your SQL query is not doing what you think it should be doing. -- 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