Reg: Derby Database Connection From Cross Platform

[Sekhar Kosuru <ko...@gmail.com>]

Hi,

I am new bie to Apache Derby, i have been asked to test the performance of
Derby database with 1000 concurrent Threads, In each thread open a
connection do one insert, select, update quries on one table.

I implemented the simulation code and tested in my local machine (Windows
7) where i am running my Derby database in networking mode.

Even i tested the same from another Windows 7 machine (Only Java Client, DB
is running in my Machine only) from my LAN.

When i am testing above simulation from Ubuntu System, i am facing lot of
issues. For opening each connection it is taking 5xxx milliseconds, where
as in other scenaios it is 2xx milliseconds.

If i am simulating upto 1000 threads means the time also increasing to get
each connection. Typically it is above 60000 milliseconds.

I observed that from wireshark is listing the follwoing error in case of
Ubuntu system.

*Protocol : ICMP*
**
*Info : Destination unreachable (Port unreachable).*
**
Surprisingly when i installed kaspersky in ubuntu machine i am not getting
this error. I am able to get connection with in 3xx milliseconds like that.

I tried with implementing the Connection Pool (Tomcat pool, DBCP, C3p0)
also.

In any case with out antivirus in ubuntu machine it is taking too much time
to get the connection and i am seeing the above error in Wireshark.

Please help me in this what could be catch here ?


Thanks in Advance.


Regards
Sekhar.

Re: Reg: Derby Database Connection From Cross Platform

[David Zanter <dz...@gmail.com>]

What does your Utilization Stats look like on the system.

ie.  CPU?, Java Heap Size and Usage? Disk IO?   I.e.  is one of those
resources being pegged?


On Fri, Aug 31, 2012 at 8:24 AM, Sekhar Kosuru <ko...@gmail.com>wrote:

> Hi,
>
> I am new bie to Apache Derby, i have been asked to test the performance of
> Derby database with 1000 concurrent Threads, In each thread open a
> connection do one insert, select, update quries on one table.
>
> I implemented the simulation code and tested in my local machine (Windows
> 7) where i am running my Derby database in networking mode.
>
> Even i tested the same from another Windows 7 machine (Only Java Client,
> DB is running in my Machine only) from my LAN.
>
> When i am testing above simulation from Ubuntu System, i am facing lot of
> issues. For opening each connection it is taking 5xxx milliseconds, where
> as in other scenaios it is 2xx milliseconds.
>
> If i am simulating upto 1000 threads means the time also increasing to get
> each connection. Typically it is above 60000 milliseconds.
>
> I observed that from wireshark is listing the follwoing error in case of
> Ubuntu system.
>
> *Protocol : ICMP*
> **
> *Info : Destination unreachable (Port unreachable).*
> **
> Surprisingly when i installed kaspersky in ubuntu machine i am not getting
> this error. I am able to get connection with in 3xx milliseconds like that.
>
> I tried with implementing the Connection Pool (Tomcat pool, DBCP, C3p0)
> also.
>
> In any case with out antivirus in ubuntu machine it is taking too much
> time to get the connection and i am seeing the above error in Wireshark.
>
> Please help me in this what could be catch here ?
>
>
> Thanks in Advance.
>
>
> Regards
> Sekhar.
>