Henning hi,<br><br>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.<br>
In testing I had with sipp and without reading or writing to disk I had 1.000CPS and 300.000 calls without any problem.<br><br>Thanks fo rhelping me<br><br>Cheers<br>Alex<br><br><br><br><br><div class="gmail_quote">On Tue, Dec 22, 2009 at 9:46 PM, Henning Westerholt <span dir="ltr"><<a href="mailto:henning.westerholt@1und1.de">henning.westerholt@1und1.de</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">On Tue, December 22, 2009 3:33 pm, alex pappas wrote:<br>
> I will check that.<br>
> In my company already are using a oracle database for portability for<br>
> other systems, so I was thinking maybe I can try and query that DB with<br>
> sqlops. I tried testing with mysql but after 30 CPS i had very bad<br>
stats. > (sipp test)<br>
<br>
</div>Hey Alex,<br>
<br>
well, 30 CPS are not that much. This looks more like a configuration<br>
problem or a slow network connection to the DB server. You could elevate<br>
this by using a local read-only replication copy on the localhost, which<br>
is easy to setup with mysql.<br>
<br>
If you want to query directly the oracle DB you could use the db_unixodbc<br>
module via ODBC, or giving the db_oracle module a try.<br>
<br>
Regards,<br>
<font color="#888888"><br>
Henning<br>
<br>
</font></blockquote></div><br>