Subject | Re: [firebird-support] FB 1.5 RC6 linear slowdown |
---|---|
Author | Thomas Miller |
Post date | 2003-09-30T14:00:09Z |
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
#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