Re: [firebird-support] Converting to firebird 3
Hi, Firebird 3 is not a silver bullet, it mostly increases performance in the multiprocessing area. With 30 connections, I would say that multiprocessing is not a problem, most likely you are having problems with SQL queries. I would suggest to take a look on https://ib-aid.com/en/articles/45-ways-to-speed-up-firebird-database/ https://www.slideshare.net/ibsurgeon/resolving-firebird-performance-problems Regards, Alexey Kovyazin IBSurgeon On 11.10.2017 12:35, 'Gian Uys' gian...@gmail.com [firebird-support] wrote: Hi 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. Is firebird 3 drastically going to improve performance and how immense would the conversion to firebird 3 be? Thanks Gian
RE: [firebird-support] Converting to firebird 3
> 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
[firebird-support] Converting to firebird 3
Hi 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. Is firebird 3 drastically going to improve performance and how immense would the conversion to firebird 3 be? Thanks Gian