RE: [firebird-support] Deletion of rows from multiple tables takes a lot of time around 30mins

Hi All, At last found the root cause for this issue basically it was database design issue where DBA used delete triggers in one of the tables let’s say ‘TableA’ that deletes it related rows from another table ‘TableB’. Another thing is are both are transaction tables containing large number

Re: [firebird-support] Firebird 3.0 - local access works, but remote acess doesn't

Make sure port 3050 is open in and out On Apr 18, 2017 4:07 PM, "Roberto Carlos rc.1...@bol.com.br [firebird-support]" wrote: > > > I am using Firebird server on a Debian 9 stretch on a Virtual Box machine > and FlameRobin client on another Windows 7 VM for

RE: {Disarmed} [firebird-support] Hint for maximaze FB performance, CPU Utilization - again.

> Each connection does get an single OS-thread only which can use no more > than an single core at the same time. On an 6-core CPU this means an > maximum of 16% utilization for total CPU. That is true for pre-v3.x SuperServer builds, not true for v3+ Not, was never, true for Classic or

Re: {Disarmed} [firebird-support] Hint for maximaze FB performance, CPU Utilization - again.

> During my development - only single connection to FB Server, I do a > lots of query. Each query took about 25-30 secs to complete, but CPU > Utilization only used at around 16% on my six cores computer. > On Ryzen 7 with 16 threads, I believe CPU utilization for FB is only 6%. > > Are there any