Hello, > we are still on FB 1.5 release, our live Database is about 50 GB. While > using the freshly restored database, things are very fast in the > beginning but they get slower and slower as weeks go by. We are always > forced to do a backup/restore after 4 weeks or so. > > In the beginning we were thinking about the database itself. a Backup > and restore would fix any speed issue but in recent days, I decided to > stop and restart FB service without DB backup and restore. After doing > so, everything was extremely fast as if we did a backup/restore. > > Do you think this is normal, every now and then a Firebird restart is > needed?
That's usually related to bad client transaction management. Once the database starts to become slow, run gstat -h on the database and check out the transaction counters and their gaps. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
