Subject RE: [firebird-support] FBTalk / Query Limits
Author Simon Carter
> -----Original Message-----
> Firebird currently has the following limits to queries:
> Maximum SQL Statement Size: 64KB
> Maximum IN List Members: 1499
> WHERE clause AND: 255
> WHERE clause OR: 1593
> Ok, This makes sense. The sql query can be no bigger than
> 64k. When one runs a "Create Procedure ... " statement in a
> script, I am making the assumption that the whole context of
> the create statement is considered one sql statement. The
> only hang up with that theory is that the "create procedure
> ... " statements that blows up is less than 64k and greater
> than 32k. All of my procedures that are less than 32k works
> just fine in the script.

AFAIU the 64k limit is down to an internal BLR limit, perhaps in later
versions of IB this limit has been removed/extended, but to be honest, I
haven't used IB since early 04. What's stated in that FAQ is the official
statistics given on this list during a previous debate.

> I can run the same script in WISQL32 and it works fine. When I run:
> C:\>isql "<path><filename>.fdb" -i "<PATH>update.sql" -u
> "EDSS" -p "edss" -o "<Path>updPT641.log" -e -m The script
> blows chucks.

I am certainly no expert on BLR, in fact what I know about BLR could be
written on the back of a stamp in 28pt font :-), but the script size != BLR
size, the 64k limit, AFAIU is the limit on BLR code.

> I would prefer not to break my procedures down below 32k if I
> don't have to.'

I can sort of understand this, however, for me personally, I would rather
have many small procedures performing specific tasks, rather than one
procedure to rule them all.


Si Carter