Subject | RE: [firebird-support] Converting to firebird 3 |
---|---|
Author | Leyne, Sean |
Post date | 2017-10-11T19:00:49Z |
> We have an application with roughly 20 000 lines of code and have been usingYou haven't provided any real details.
> firebird 2.5 since the start. We do experience performance problems with
> 30+ client connections and are thinking of moving to firebird 3.
Are you using SuperServer or Classic engine?
What are you DB Page cache settings?
What is your DB page size?
Have you used gstat to check that you don't have long running transactions?
Have you used gstat to check the "depth" value of your indexes? (should be less than 4)
Sean