Subject Re: [firebird-support] Upgrade to FB2.01 and performance drops
Author Helen Borrie
At 05:19 AM 18/05/2007, Trevor Toms wrote:
>We've just upgraded one of our servers from V1.5.3 to V2.01 and
>performance has plummeted.
>One particular query that runs on the old V1.5.3 takes around 7
>seconds, but this has shot up to over 600 on V2.01! Overall
>performance on most queries has dropped badly.
>We backed up the database fo v1.5.3 and restored it into V2.01 using
>IBOConsole, and all superficially seemed OK, but users started
>complaining of poor performance almost immediately.
>We've tried using another server, and this also took over 300 seconds
>to run the query (it's a better server). We then uninstalled V2.01,
>reinstalled v1.5.3 on this second server, restored the database and
>the query ran in 3 seconds!
>Now, the only thing tht seems odd, is that when restoring the
>database with IBOConsole, V1.5.3 shows messages "gbak: restoring
>index IDX_XXX", while V2.01 shows messages "gbak: activating and
>creating deferred index IDX_XXXX".
>The performance drop would be consistent with there being no indexes
>or inactive indexes in the newly restored database. However, all the
>indexes show as active in IBOConsole.
>Any clues to what is happening here?

Is it a dialect 1 database?