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" <[email protected]> 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" <[email protected] > > 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" <[email protected]> >>> To: [email protected] >>> 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 >>> [email protected] >>> 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 >> [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 -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
