Subject Re: [firebird-support] Re: Trace cause of performance drop
Author Mark Rotteveel
On Tue, 16 Dec 2014 12:00:45 +0100, "Jesus Garcia jegaza@...
[firebird-support]" <> wrote:
> 2014-12-16 9:39 GMT+01:00 Mark Rotteveel mark@...
> [firebird-support] <>:
>> My first suggestion would be to upgrade to 2.5.3 Update 1 and backup
>> restore your database.
> Why is needed to backup + restore the database when upgrade to 2.5.3. As
> know is only necessary to avoid lock conversion denied. Is there
> else?

I don't know the history of this DB, for all I know it was created with
2.5.1 and suffers from the index bug. Also given the described problem,
recreating the database (what a restore does) might solve it as well. I
admit it is an easy answer to what might be a complex problem.