Hi Rajesh

I have been reading this discusion with interest.

We have the same behaviour, the users tell us the application slows up
as the day progress.
As far as I can tell the only tuning you can do is a backup and restore.
We have done this but we have the same problem.
Our PHP application is running on Apache and we have common OS Win XP
Pro.
I don't have a win 2000 server box but will be making it up. I suspect
Win XP. The XP box is a 2 GHZ athlon with 1 GB
RAM.

Firebird is also new to me and looks to be a great db. I have been
building data base apps for the last 20 years and this has got me
stumped.

Victor

-----Original Message-----
From: Rajesh Punjabi [mailto:rajesh@...]
Sent: Tuesday, 30 September 2003 7:42 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] FB 1.5 RC6 linear slowdown


Hi Martijn,


Martijn Tonies wrote:

>
>These are the transaction counters.
>

Thanks!

>
>Is this while the database is slow?
>

Yes and FB is slowing down even more as we speak. When we started out
with a clean Database, one request used to take 19 secs (as compared to
9 on MySQL). Now after 300 requests it takes 60 Secs. MySQL processed
5000 sequential requests with no visible degradation and oracle
processes the same number without degradation either.

>
>Many times when someone complains his app is slow, it's
>because there are long running transactions, causing
>lots of garbage/transaction information to be kept...
>
>

There are long running transactions...but the length of the transaction
is per request...so not more than a minute.

>If these counters are from a time while your db app is
>slowish, then this isn't the case...
>
>

One thing I did notice is that our application (or JBoss container)
acquires 100+ locks per request. I dont know if this is normal never
having used Firebird before.

Thanks
Rajesh



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=251812.3856299.5103760.1261774/D=egroupweb/S=1705
115386:HM/A=1754451/R=0/SIG=11tkldm5d/*http://www.netflix.com/Default?mq
so=60178323&partid=3856299> click here

<http://us.adserver.yahoo.com/l?M=251812.3856299.5103760.1261774/D=egrou
pmail/S=:HM/A=1754451/rand=924936468>

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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