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.