Thank you for your response.

I haven't tried the stress test java program using another database.
But I have another test. The test is done like this:

A Delphi based program is querying data from local database Microsoft
SQL Server on Windows 2000 Operating system, 512 MByte, Pentium IV 2,4
GHz.
A java based program is querying data from local database Firebird on
Windows 2000 Operating system, 512 MByte, Pentium IV 2,8 GHz.

The delphi based program and java based program are doing the same
thing is that just to query data from database.
(The database structure (including fields) are almost the same except
the table names).

The result shows :
delphi based program took 1 minute and 10 seconds to finish while
java based program took 1 minute 35 seconds.

The number of returning records is about 12000 recods.

When i noticed the memory usage firebird database only consumed about
19000K while Microsoft SQL Server 2000 consumed about 300000K.


The point why i compare the java and deplhi program is because i am
currently trying to convert delphi based program into java based program.



Regards,
Ferry



--- In Firebird-Java@yahoogroups.com, "Gabriel Real"
<gabrielprogramador@...> wrote:

>
> I don't know how to help you, but I'm curious...
> Have you ever tryied this test with any other database like MySQL, SQL
> Server Express? Wouldn't it happen the same about de consuming CPU?
>
> Thanks
>
> Gabriel
>
>
> 2007/6/29, ferry_new2004 <ferry2004@...>:
> >
> > Hello everybody,
> > I am a newbie firebird user. I am wondering about how to tune
> > firebird database up. In my testing, I use two java batch programs to
> > do select/insert/update process repeatedly (each program will create
> > 1000 records) just to test the response time. The testing is done

with :

> > - FirebirdSS-2.0.1.12855-0.nptl.i686.SUPERSERVER.rpm
> > - LINUX mandrake 10.2
> > - The machine specification is Pentium IV 1,8Ghz and memory 256MB
> > (acting as database server, while the java programs resides on another
> > computer, th lan connection bandwidth is 100MBps).
> > - Isolation level of transaction is REPEATABLE READ
> > - Database record number is only about 17000 records.
> > - No blob (binary large object) field used
> >
> > When the testing was running, I noticed that firebird consumed CPU
> > Time (about 90%). At this condition, if another program tried to do
> > the same thing, the response time dropped significantly (3-4 times
> > slower).
> >
> > In my opinion this is because the CPU Usage of firebird.
> > I am wondering whether there are tips and tricks to reduced the CPU
> > Time so that more java batch program can concurently run ( I assumed
> > the condition as the busiest condition).
> >
> > Confusing with the problem, I also tested the same system on different
> > machine (Pentium IV 2,4 GHz and memory 512MB). Unfortunately, the CPU
> > usage was still about 90% which was consumed by the firebird. ( I used
> > 'top' command to monitor the CPU usage). :(
> >
> > I tried to reduce the transaction isolation to be READ COMMITED (the
> > shallowest one of firebird) but it only reduced by about 10% - 15%, it
> > means the CPU usage of firebird was still about 70%-80%.
> > It seems to me that the better machine specification used (Pentium IV
> > 2,4 GHz and memory 512MB) did not reduce the CPU Usage of firebird
> > process. :(
> >
> > Does anyone have any idea to tune firebird database up ? :)
> >
> > Thank you & Regards,
> > Ferry
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>