Subject Re: [IBO] TIB_Connection Domain and SQLType Entries
Author Helen Borrie
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".