[Freeswitch-users] High load on database server

[Madovsky]

I means that depend the quality of your script ;)

----- Original Message ----- 
From: "Hynek Cihlar" <hynek.cihlar at gmail.com>
To: "FreeSWITCH Users Help" <freeswitch-users at lists.freeswitch.org>
Sent: Thursday, October 27, 2011 3:46 AM
Subject: Re: [Freeswitch-users] High load on database server


> What does it mean? That I cannot access the DB from scripts?
>
> Sent from my mobile device
>
> On Oct 27, 2011, at 8:21, "Madovsky" <infos at madovsky.org> wrote:
>
>> possible that you have somwhere redundant SQL request from your script or
>> dialplan...
>>
>> ----- Original Message -----
>> From: "Madovsky" <infos at madovsky.org>
>> To: "FreeSWITCH Users Help" <freeswitch-users at lists.freeswitch.org>
>> Sent: Thursday, October 27, 2011 2:15 AM
>> Subject: Re: [Freeswitch-users] High load on database server
>>
>>
>>> try the version 2.3.0 of ODBC (compiled from sources)
>>> I can't tell you if it will work because I never had more than 20
>>> councurrent calls
>>> but it should be better anyeway
>>>
>>> ----- Original Message -----
>>> From: "Cliff Wells" <cliff at develix.com>
>>> To: "FreeSWITCH Users Help" <freeswitch-users at lists.freeswitch.org>
>>> Sent: Thursday, October 27, 2011 2:02 AM
>>> Subject: Re: [Freeswitch-users] High load on database server
>>>
>>>
>>>> On Wed, 2011-10-26 at 11:12 -0500, Anthony Minessale wrote:
>>>>> if you have older unixodbc edit /etc/odbcinst.ini and add the param
>>>>> Threading=0 to each db entry.
>>>>
>>>>> In general postgres to me appears to care more about multithreaded
>>>>> environments and with the above threading=0 change works pretty well.
>>>>
>>>> I tried this (after googling a bit and coming across an older thread 
>>>> you
>>>> responded to) and it didn't change anything.  Crashes at ~330 
>>>> concurrent
>>>> calls like clockwork.  This was with unixODBC 2.14 and PostgreSQL 8.4
>>>> odbc driver.
>>>>
>>>> Regards,
>>>> Cliff
>>>>
>>>>
>>>>
>>>>
>>>> FreeSWITCH-users mailing list
>>>> FreeSWITCH-users at lists.freeswitch.org
>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>> http://www.freeswitch.org
>>>
>>
>>
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org