Stored Procedure größen limitiert?

[ibp]

Hallo,

gibt es eine Größenlimitation von Stored Procedures?

[mkinzler]

Größenbegrenzug für was? Code, Ergebnis?

[Sir Rufo]

Zitat von mkinzler:

Größenbegrenzug für was? Code, Ergebnis?

Oder Parameter?

[Piethan]

Zitat:

Currently the maximum size of a stored procedure or trigger in Firebird and InterBase® is 48 KB of BLR (the size of the byte code language compiled from stored procedure or trigger language and not the source code itself, which may include comments). However, as this comprises well over 1,000 lines of code, it is wiser to split any procedures of this size into smaller ones anyway, as this will improve not just the readibility and ease of maintenance but also, more often than not, the efficiency

http://www.ibexpert.info/ibe/index.p...TOREDPROCEDURE

Ich würde in diesem Fall versuchen alles in mehrere Prozeduren aufzuteilen.

[ibp]

Zitat von Piethan:

Zitat:

Currently the maximum size of a stored procedure or trigger in Firebird and InterBase® is 48 KB of BLR (the size of the byte code language compiled from stored procedure or trigger language and not the source code itself, which may include comments). However, as this comprises well over 1,000 lines of code, it is wiser to split any procedures of this size into smaller ones anyway, as this will improve not just the readibility and ease of maintenance but also, more often than not, the efficiency

http://www.ibexpert.info/ibe/index.p...TOREDPROCEDURE

Ich würde in diesem Fall versuchen alles in mehrere Prozeduren aufzuteilen.

danke, das genau war es leider... also muss ich splitten....