On Thu, 22 Feb 2001 11:17:10 -0500, Ann W. Harrison wrote:

>At 03:55 PM 2/22/2001 +0200, Gerhardus Geldenhuis wrote:
>
>
>>I have noticed that IB creates a domain for fieldtypes that is not
>>domains.(Explicitly defined by user as domain)
>>Why is this ?
>>Would it be better to create a integer domain or such like, instead of
>>having RDB$XXX you will only have +-50 domains.
>

(snip lots of good stuff)

>
>Certainly, if you wish, you can define domains for the common
>fields types and reduce the number of domain definitions, but
>even a very complex schema has relatively few fields - in the
>thousands, perhaps, but not in the millions. The database is
>designed to handle millions of rows. The size of RDB$FIELDS
>just isn't an issue.

Ok. But ease a lot maintenance using explicit domains.

>Ann
>www.ibphoenix.com
>We have answers.

I never doubted of this... ;-)

[]s Fabricio
Systems Developer