Subject Re: Speed of Firebird v1.52 vs. Interbase v7.1
Author Steve Harp
--- In, "Alan McDonald" <alan@m...>
> > 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
> 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

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