Hi, just want to tell you that if you want so see what performance you'll get out of your OpenSER proxy, I found out by using a software called super-smack I easily can generate a typical OpenSER sql query and see how many qps I can get.
...nice to have :-)
br hw
Hi Helge,
so this "super-smack" is more a tester for DB?
regards, bogdan
Helge Waastad wrote:
Hi, just want to tell you that if you want so see what performance you'll get out of your OpenSER proxy, I found out by using a software called super-smack I easily can generate a typical OpenSER sql query and see how many qps I can get.
...nice to have :-)
br hw
Hi, yes that's correct. you'll be able to test different scenarios; in simplest way select statements. (ex: query from 10 clients, 1000 per client) If you combine different table lookups, you'll see the performance numbers for queries per second.(In addition to several others max/min connect time etc)
For my own project I've done testing on several OS'es and platforms to decide which has the best performance.
I mean, seeing number for cps for a SIP proxy just routing packets makes no sense to me, since most installations do several db queries (ACL etc etc)
For instance cacheless usrloc performance......
...and fun to see performance improvement by loading avps from database.....
I always like to have a few achademic numbers in my documentation :-)
Mvh/br, Helge Waastad Senior Engineer Smartnet
-----Original Message----- From: Bogdan-Andrei Iancu [mailto:bogdan@voice-system.ro] Sent: Tue 6/13/2006 6:10 PM To: Helge Waastad Cc: Users@openser.org Subject: Re: [Users] OpenSER performance
Hi Helge,
so this "super-smack" is more a tester for DB?
regards, bogdan
Helge Waastad wrote:
Hi, just want to tell you that if you want so see what performance you'll get out of your OpenSER proxy, I found out by using a software called super-smack I easily can generate a typical OpenSER sql query and see how many qps I can get.
...nice to have :-)
br hw
Hi Helge,
Helge Waastad wrote:
If you combine different table lookups, you'll see the performance numbers for queries per second.(In addition to several others max/min connect time etc)
For my own project I've done testing on several OS'es and platforms to decide which has the best performance.
Actually, this sounds very interesting for anybody on this mailing list. Could the results be published [on the list]? An academic wrapper might not be necessary, some raw data would probably be just fine. :)
I mean, seeing number for cps for a SIP proxy just routing packets makes no sense to me, since most installations do several db queries (ACL etc etc)
For instance cacheless usrloc performance......
...and fun to see performance improvement by loading avps from database.....
You are touching a soft spot here. I've always appreciated the storage backend is slower (and slowing the whole thing down) by at least one magnitude order, in most of reasonable featured OpenSER deployments. Is there any data you could provide us with, on the topic?
Regards, Gill.
-
Bogdan-Andrei Iancu -
Gill Bates -
Helge Waastad -
Helge Waastad