Will do,

Thanks Jason.

Regards

Peter

-----Original Message-----
From: IB Objects [mailto:jwharton@...]
Sent: Saturday 28 June 2003 10:30 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Re: FW: IBO seems slower for some things compared
with the BDE


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



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/