Subject | Firebird with Tomcat on Linux |
---|---|
Author | Marco Lovato |
Post date | 2005-02-28T07:48:36Z |
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]
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]