|Subject||Firebird database executing DML queries very slowly.|
I am facing an issue on my client end where Firebird database is very slow in executing DML queries. I ran the customer database on my machine, it was working smoothly without any lag. This same database copied on customer machine gets very slow in executing DML queries. I replaced the firebird database with a fresh one, it worked without any lag for few days and thereafter slowed down.
Quite, similar to this another customer faced an issue in FB database, where generator reset was getting stuck on an transaction table due to this no DML queries was getting executed. This same DB copied on our machine had no issue on performing DML on same transaction table.
This is the first time I am facing this issue, I doubt on their environment as both the databases where working fine till few weeks back.