| Subject | Re: [firebird-support] Converting to firebird 3 |
|---|---|
| Author | Alexey Kovyazin |
| Post date | 2017-10-12T10:49:24Z |
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' gianuys@... [firebird-support] wrote:
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' gianuys@... [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