[OpenSIPS-Users] Sorting Lists of Data

[Brad Bendy]

I've done this I'm the past at around 150 cps we ran into problems, maybe running partitioning it would be ok. If you could cache enough RAM you might be able to push it well past that.
My concern would be can avp_db_query hogging the system down, soon I am going to test with db_http and see how that works out.

"Brett Nemeroff" <brett at nemeroff.com> wrote:

>I'm concerned That the performance at high CPS would be seriously
>impacted.
>
>Any benchmarks on this??
>-Brett
>
>
>
>
>On May 13, 2010, at 7:47 PM, "Matthew S. Crocker" <matthew at corp.crocker.com
> > wrote:
>
>>
>> Could you put the data in a SQL database then 'Select * from
>> db_table order by price'?  Let the database do the sorting?
>>
>> -Matt
>>
>> ----- Original Message -----
>>
>>> From: "Brett Nemeroff" <brett at nemeroff.com>
>>> To: users at lists.opensips.org
>>> Sent: Thursday, May 13, 2010 8:06:01 PM
>>> Subject: [OpenSIPS-Users] Sorting Lists of Data
>>>
>>> Hello All,
>>> I'm looking to numerically sort data.. Basically what I need is an
>>> array
>>> with numerical data values to be sorted (yes, for pricing)
>>>
>>>
>>> $avp(s:price)[0]=0.0125
>>> $avp(s:price)[1]=0.0138
>>> $avp(s:price)[2]=0.0128
>>> $avp(s:price)[3]=0.0112
>>> $avp(s:price)[4]=0.0005
>>> $avp(s:price)[5]=0.0149
>>>
>>>
>>> And I'd like to....
>>>
>>> <magic>
>>> $avp(s:price_sorted) = avp_sort("$avp(s:price)");
>>> </magic>
>>>
>>> Is that possible with.. anything? It doesn't need to be an AVP.. just
>>> looking for any sortable data structure.
>>>
>>> Thanks,
>>> Brett
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>> --
>> Matthew S. Crocker
>> President
>> Crocker Communications, Inc.
>> PO BOX 710
>> Greenfield, MA 01302-0710
>> http://www.crocker.com
>> P: 413-746-2760
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>_______________________________________________
>Users mailing list
>Users at lists.opensips.org
>http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-- 
Sent from my Android phone with K-9 Mail. Please excuse my brevity.