--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > Hi All,
> >
> > I have switched a client's application from Interbase v7.1 to Firebird
> > v1.52. I've made no other changes to the application except the
> > database server. The application uses IBO for connectivity.
> >
> > One of the users claims that the application is now slower. Could
> > there be any truth in this? I've never heard of Firebird being slower
> > than Interbase.
> >
> > Thanks,
> > Steve
>
> easily done if your indexes are wrong/don't match the optimizer

plan. If you

> went the other way it's possible Interbase is slower than FB for the

same

> reason
> Alan

I didn't change any indexes. The way I create the FB database was to
generate a script from IBExpert using the Interbase database and use
this to create the FB database. Then I backed up the Interbase
database and used Firebird to restore it into a temporary database.
Lastly, I copied the data from the temporary database into my new FB
database.

The FB database should be an exact duplicate of the Interbase database.


Steve