|Subject||RE: [firebird-support] FBTalk / Query Limits|
> -----Original Message-----AFAIU the 64k limit is down to an internal BLR limit, perhaps in later
> 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.
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 am certainly no expert on BLR, in fact what I know about BLR could be
> 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.
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 II can sort of understand this, however, for me personally, I would rather
> don't have to.'
have many small procedures performing specific tasks, rather than one
procedure to rule them all.