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
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:
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
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]
> 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
>
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
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
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