Subject FW: IBO seems slower for some things compared with the BDE
Author Peter McLeod
> I have an application which I have just ported from the BDE to IBO. I then noticed that the application took longer to load compared with the same application using the BDE (48 seconds compared to 6 seconds).
>
> In order to quantify where the differences were, I then used Sleuth stopwatch to time the two programs. During this time I noticed that IBO seemed to be slow as it was retrieving information about the database (according to Codewatch the time differences coudld be attributable to the functions/procedures SchemaIndexDefinitions, SchemaDefaultedCols and SchemaProcedureInfo, SchemaPrimaryKeyInfo from IB_Schema.pas, and SysGetBlobData from IB_Session).
>
> On the whole examing the time taken for other processes was faster than using the BDE, it was the retrieval of the database information which slowed the whole thing down.
>
> Does anyone know why IBO needs to retrieve this information, or could it be in the porting I have a BDE setting which is causing things to slow down?
>
> Any assistance would be greatly appreciated.
>
> Regards
>
>
> Peter Mc Leod
>
>
>
>
>
>
>