--- In firebird-support@yahoogroups.com, Daniel Rail <daniel@a...> wrote:

>
> Hi,
>
> At November 15, 2005, 8:12 AM, Dilish wrote:
>
> > am creating a comparison with MSAcces,MSDE & FireBird
> > The following are my queries
>
> > Max. No.Of Columns
>
> Depends on the datatypes used for the fields. The maximum row size
> can be 64KB (BLOBs not included, since they are not stored within the
> row)
>
> > Max. No. of columns per query
>
> My guess is that it would be the same as above. And, still excluding
> BLOBs from the calculation.
>
> > Max. No. Of Tables per Query
>
> 256 joined tables.
>

The other limit that might be of interest at these sorts of numbers of
joins etc is the maximum size of a single statement is 64KB.

You might want to review this site:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;FAQS;NAME='System+Limits'

Note that certain limits have been increased in Firebird 2.

Adam