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