The query´s prepare/execution time don´t alter if I drop fetSQLType but
if I drop the fetDomain it goes from 28 to 4 seconds. Really I don´t need
fetSQLType, all fields that i´m setting are covered by its domain (about 10
domains). The connection´s columnattributes have 7 entries (to define
Boolean, some domains´s notrequired, etc) and the fields stringlists
(fieldscharcase, fieldsdisplayformat, fieldsdisplaywidth, fieldseditmask,
fieldsgridlabel and fieldsvisible) have many entries (not all domains for
each one).

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, October 21, 2002 10:06 AM
Subject: Re: [IBO] TIB_Connection Domain and SQLType Entries


At 09:00 AM 21-10-02 -0200, you wrote:
> I have defined some column and fields attributes in TIB_Connection
> and using Domain Entries and SQLTypes Entries from this connection. I
> noticed that it´s turning my queries slow (very slow in some cases). In
> small queries (2 , 3 fields) this isn´t realized but I have one query,
> for example, with many fields and joins, that take 28 seconds to prepare
> and without Domain and SQLType entries take 3 seconds. There´s any way to
> optimize it?

What happens if you drop fetSQLType and just use fetDomain? For db columns
that you don't define under domains, the database creates its own domains
internally. fetDomain should (theoretically) be sufficient to cover all
cases and avoid "double-dipping".

Helen



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