Subject Firebird 2.0 - 1.5 fbclient diference
Author ales.lesnika
I'm migrating 3 tier Delphi 7.0 application (DBExpress,
COMConnection, ClientDataSet) from Firebird 1.5.3 to Firebird 2.0.0
database server. However I've noticed significant decrease in
performance. My application start up time increased for more than 10
times, ...

I've profiled application and noticed that most of the start up time
is spent in procedure (SqlExpr.pas)


in line

Status := GetInternalConnection.FSQLMetaData.getIndices(Pchar
(FschemaInfo.ObjectName, 0, FSQLCursor))

I've converted database to the new 11.0 format (FB 1.5 backup - FB
2.0 restore), but performance is the same.
I've read that index structure changed in the new ODS 11.0 format.

Is it possible that this performance degradation is somehow
connected to this change?