Subject Firebird + Tomcat + Localhost
Author Marco Lovato
Hi all,

I am in trouble.
I developed an application in Java to run under Windows.
Worked ok, but we changed it to Linux (in that case, Conectiva Linux).
And then firebird simply got extremely slow on same application.

So I tested on my notebook. I have WinXP (the app worked properly).
But when turning to Gentoo, same thing has ocurred... superslowmotion.
The app makes the query, and hangs for 10-15 secs (with CPU 0.5%).

Does anybody have a clue? What kind of tune has to be made?

This happens ONLY at this circustance:

- Linux
- Firebird
- Tomcat using jdbc
- Connection to LOCALHOST

If the database is on another machine, or someone else (a tomcat on
other machine), everything goes fine.

Code:
mcfly lib # cat /etc/hosts
127.0.0.1 mcfly localhost mcfly

Code:
mcfly lib # cat /etc/hostname
mcfly

The poor performance:


[13:16:37] DEBUG
com.aero.mb.report.NewReportExtractionAction:841
#files = 46
[13:16:58] DEBUG
com.aero.mb.report.NewReportExtractionAction:899
Processing File: #1


Can you see the superdelay? 21 secs? Normally it is less than 1 sec.
And if I use another database (another machine) this do not happen.
And also if someone uses only my database.

Thanks

Marco


[Non-text portions of this message have been removed]