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:

Zitat von mkinzler (Beitrag 1094148)

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:

Zitat von Piethan (Beitrag 1094172)

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....