Subject RE: [firebird-support] Converting to firebird 3
Author Leyne, Sean
> We have an application with roughly 20 000 lines of code and have been using
> firebird 2.5 since the start. We do experience performance problems with
> 30+ client connections and are thinking of moving to firebird 3.

You haven't provided any real details.

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