Subject Re: [IBO] Re: FW: IBO seems slower for some things compared with the BDE
Author IB Objects
I suggest that your database must have a lot of tables/fields/etc and the
queries I have on the metadata are not so quick since there are no default
indexes on metadata tables.

Please examine the queries I use in the SQL trace monitor and see if some of
them are performing poorly. Then, once those are identified, try creating
some indexes that would allow the server to perform those queries much
faster.

It would also be useful to make a TI on this so that we can assist others
who have larger metatada definitions in their databases.

Jason Wharton