gwc8182 wrote:

> Dear All,
>
>
> My question is what could have happened that required
> dropping and recreating the database? I would suspect
> the index is somehow corrupted, if that the case, any
> way I could also check for that since gbak didn't pick
> it up ?
> If the index not optimised correctly, doesn't the gbak
> restore create back the index correctly ?
> Could it be the firebird version being a bit too old?
> Though am planning to move to Firebird 2.0.1
> A year or two ago, I did encounter the same problem
> before from a different customer with different
> computer setup, but the firebird version was the same.
>
>
> Just Wondering.......
> John
>
>
>

Perhaps the indices statistics are out of date.

Every time you found a difference in speed between the same statement on
two databases, the first think to look are the used plans on each case.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br