db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Zanter <dzan...@gmail.com>
Subject Re: Reg: Derby Database Connection From Cross Platform
Date Fri, 31 Aug 2012 12:47:39 GMT
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 <kosurusekhar@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.

View raw message