> --- 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

that's fine but one area where FB has diverged from interbase (probably
quite significantly) is the optimiser.
You should now check that your application queries are being correctly
interpreted by the FB optimiser. Some tables may need additional/different
(ascending/descending) indexes.
When you (your client says) slow - do they mean overall or are they
referring to some actions (which are related to certain queries in your app?
Alan