I am relatively new to Fireird, and I have been experiencing
intermittent performance issues with the database over the last
several weeks. The server is Windows/2000 and the client workstations
are a mix of Win/2000 and XP machines. We are on Firebird version 1.5,
the client application is a .net application and we are using the
Firebird .net provider version 1.6. It seems as though all of a
sudden, for no reason at all the entire application begins to run
extremeley poorly with unacceptable reponse times. I ran gfix this
lastest time and forced the database shutdown, ran a verification (no
errors reported) and brought the database back on-line and magically
everything seems to be back to normal. Is it possible that there is an
open connection that could be causing a problem?, or a number of open
connections that aren not being closed?. Is it an indexing problem of
not having enough indexes built? Is there an issue with the .net
provider? I know I am reaching for straws, but any assistance with
what could be going on would be gratefully appreciated.