Henning hi,

In the server I'm running Kamailio I have a good CPU(4 cores) and 2G memory but for reading or writing to the disk i have a big problem.Is a blade server with very bad disk which they do also software raid 1. Even if I try to write in the log file of kamailio I get such  a high load that I cannot pass the 10 CPS. This is the reason on why  I try through a network connection. Apparently i found out that also the second server that I'm writng in mysql is the same blade so now I will try to get data from the Oracle which is a good server.
In testing I had with sipp and without reading or writing to disk I had 1.000CPS and 300.000 calls without any problem.

Thanks fo rhelping me

Cheers
Alex




On Tue, Dec 22, 2009 at 9:46 PM, Henning Westerholt <henning.westerholt@1und1.de> wrote:
On Tue, December 22, 2009 3:33 pm, alex pappas wrote:
> I will check that.
> In my company already are using a oracle database for portability for
> other systems, so I was thinking maybe I can try and query that DB with
> sqlops. I tried testing with mysql but after 30 CPS i had very bad
stats. > (sipp test)

Hey Alex,

well, 30 CPS are not that much. This looks more like a configuration
problem or a slow network connection to the DB server. You could elevate
this by using a local read-only replication copy on the localhost, which
is easy to setup with mysql.

If you want to query directly the oracle DB you could use the db_unixodbc
module via ODBC, or giving the db_oracle module a try.

Regards,

Henning