Subject Re: [firebird-support] FB 1.5 RC6 linear slowdown
Author Thomas Miller
The problem is likely one of two issues (or both)

#1) Memory leak in client. You mentioned you have a pool. Structure
the pool
to periodically close a pool connection and restart a new one.

#2) There has been a problem with the garbage collection running in its
own
thread. It seems that the amount of garbage that may accumulate is more
then
the threads alloted time to do the clean up, so it does no clean up. During
the day, this kills performance. Supposedly it was fixed for RC5??, but
maybe
not.

Try #1 first and see if it helps. Maybe if a connection is more then
one hour
old and idle, kill it and make a new one.

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus