actually, I think avp_db_query with that many calls might be ok, YMMV.
Really depends on the overall application and what the expectations are...
if the writes are bursted to 200 or sustained.. etc..



On Sat, Jul 24, 2010 at 1:25 PM, Laszlo <[email protected]> wrote:

> Brett is right, but avp_db_query can be a performance killer too (just
> imagine it with 200 new calls per second = 200 insert queries/sec)
>
>
> -Laszlo
>
> 2010/7/24 Nauman Sulaiman <[email protected]>
>
>> Thank you for the respnses
>>
>> --- On *Sat, 24/7/10, Brett Nemeroff <[email protected]>* wrote:
>>
>>
>> From: Brett Nemeroff <[email protected]>
>> Subject: Re: [OpenSIPS-Users] Run custom PHP script to send SMS upon
>> receiving invite
>> To: "OpenSIPS users mailling list" <[email protected]>
>> Date: Saturday, 24 July, 2010, 15:59
>>
>> The exec module has a huge performance penalty. I'd avoid it if high
>> performance is required. I don't know anything about your application, but
>> if the time delay between the invite and the SMS isn't too sensitive, you
>> could consider using avp_db_query to insert a queued notification to a SMS
>> message.
>>
>> Alternatively, you could use avp_db_query with db_http to post a realtime
>> SMS notification, but you'd need to create a db adapter per db_http; it
>> shouldn't be too hard at all. The perl module is also very good, but I'm not
>> sure how up-to-date it is.
>>
>> -Brett
>>
>>
>>
>> On Sat, Jul 24, 2010 at 7:48 AM, Laszlo 
>> <[email protected]<http://mc/[email protected]>
>> > wrote:
>>
>>> Sounds like a bad idea :)
>>>
>>> You can try to play with the exec module, see
>>> http://www.opensips.org/html/docs/modules/1.6.x/exec.html
>>>
>>> -Laszlo
>>>
>>>
>>> 2010/7/24 Nauman Sulaiman 
>>> <[email protected]<http://mc/[email protected]>
>>> >
>>>
>>>>  Hi, using OpenSIPs 1.6, how does one run a custom php script (or
>>>> whatever code) upon
>>>> receiving incoming INVITE. We need to perform some custom action ie send
>>>> SMS message
>>>> when receiving an INVITE. With asterisk one can use the System function
>>>> in DialPlan
>>>> what is the equivalent way with OpensSIPS.
>>>>
>>>> Thanks
>>>>
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> [email protected]<http://mc/[email protected]>
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> [email protected] <http://mc/[email protected]>
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>
>> -----Inline Attachment Follows-----
>>
>>
>> _______________________________________________
>> Users mailing list
>> [email protected] <http://mc/[email protected]>
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>
>> _______________________________________________
>> Users mailing list
>> [email protected]
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
> _______________________________________________
> Users mailing list
> [email protected]
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to