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

Hi Karol, I will look into how the delete query plan works on customer environment and will revert back. Thanks From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 18 April 2017 20:16 To: firebird-support@yahoogroups.com Subject: Odp:

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

Hi Sean, I will look into it and will revert-back with additional details. Thanks. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 18 April 2017 20:13 To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] Deletion of rows from

[firebird-support] Hint for maximaze FB performance, CPU Utilization - again.

Hi guys, I am using FB 3.02 in Superserver mode. 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

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

I am using Firebird server on a Debian 9 stretch on a Virtual Box machine and FlameRobin client on another Windows 7 VM for testing. There is no firewall activated. I can access the database locally using isql-fb. I have installed Firebird 3.0 via Debian oficial packages: # apt-get install

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

Hi, For me 5 minutes looks also very long. Look how delete query plan looks like Regards, Karol Bieniaszewski - Reply message - Od: "Joje j...@codework-solutions.com [firebird-support]" Do: Temat: [firebird-support]

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

> Today one of our customer complained that removing clients from > application is taking a lot of time around 30-40mins.  So I looked into their > database whose DB size is around 340MB and found that our DBA has a called > deletion triggers in main table. Triggers will delete all the client >

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

Hi martin, Thanks for help but firebird database is in Windows server 2008 OS. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 18 April 2017 16:54 To: firebird-support@yahoogroups.com Subject: [firebird-support] Deletion of rows from

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

Hello Joje, please check the file system. We had a similar issue with btrfs on OpenSuse several months ago. After switching to ext4 everything went fine. Maybe it was a problem with the file system's journaling option. Regards Martin

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

Hello, Today one of our customer complained that removing clients from application is taking a lot of time around 30-40mins. So I looked into their database whose DB size is around 340MB and found that our DBA has a called deletion triggers in main table. Triggers will delete all the client