db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knut Anders Hatlen <Knut.Hat...@Sun.COM>
Subject Re: Howmany concurrent users are supported by network server
Date Sat, 11 Mar 2006 15:16:02 GMT
Manjula G Kutty <manjula.kutty@gmail.com> writes:

> Knut Anders Hatlen wrote:
>>Manjula G Kutty <manjula.kutty@gmail.com> writes:
>>>I would like to know an estimate of howmany concurrent users are
>>>supported by derby network server. I know its hardware dependent, but
>>>for instance assuming a Windows box w/ 2Gb memory, single CPU, single
>>>7200rpm IDE drive.. Each user will be doing insert, delete, update and
>>What do you mean by supported? The number of concurrent connections
>>you can have without running out of memory? The number of concurrent
>>connection you can have with acceptable performance, for some
>>definition of acceptable? Something else?
> Hi
> Thanks for taking time to look into my mail.
> I would like to get the number of concurrent connections you can have
> with acceptable performance.

It's not possible to give an exact answer, since it depends on what
you consider acceptable, the type of load, the size and layout of your
tables, etc. However, to give an indication, I ran a test with up to
1000 concurrent connections. The attached graph shows the throughput
and average response time for an increasing number of connections.

The test clients operated on a 10 MB table (100 000 rows, 100 bytes
each). Each client executed one single-record operation (accessed by
primary key) per trasaction, of which 10% were insert operations, 10%
delete, 50% select and 30% update operations. The network server was
configured with 64 MB page cache, log and data were stored on separate
disks. Hardware configuration: 2x2.4GHz CPU, 2 GB RAM, 2 SCSI disks
(7200 rpm), disk write cache disabled. OS/JVM: Solaris 10 x86/Sun JVM
1.5.0. Derby version used was 10.2 (trunk).

The average response time for this mix of transactions is half a
second at 600 concurrent connections, one second at 850 clients and
1.5 seconds at about 950 clients. Maximum throughput is achieved at
about 150 connections.

Other configurations/workloads might give completely different
results, so YMMV.

Knut Anders

View raw message