Thanks for the input. I'll suggest this to my developer. I would imagine
checking the "unclose" db connection in the source code gonna take some time
because this is a very huge application. While waiting for the dev team to
finish on that, the production system need to go on. The only temporary
measue is to do a backup restore to improve the db performance...


p/s: I'm in the middle of testing my script to do an automated
backup-restore
http://marjan.blogsome.com/2006/10/06/autobot-unite-and-fire/

On 10/6/06, Michael Weissenbacher <mw@...> wrote:
>
> Hi,
> > If it matters the application that uses this db is a web base java
> > application.
> Make sure you use the latest JayBird JDBC Driver. We've had issues with
> hanging transactions with some of the older versions (from around 2003).
> Other than that I can only suggest you to check your code and any
> Connection Pooling mechanisms you might use.
>
> Michael
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>


--
And whoever does an atom's weight of evil will see it.


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