Large Stored procedure (OpenInsight 32-Bit) [Revelation On-Line Wiki]

OpenInsight 32-Bit, Chris Meyer, Kauko Laurinolli, Bob Carten

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 27 MAR 2010 01:53:04AM Chris Meyer wrote:

I have a stored procedure I use to fix customer data. It keeps on getting bigger and bigger.

Number of lines=3134

Number of Characters=78164

Without including 18 inserts

In AREV each of my fixup routines were a separate records in my BP_FIX file.

Is there a size limit to a stored procedure, I'm not having any problems at the moment. Just wondering.

Chris

At 27 MAR 2010 06:25AM Kauko Laurinolli wrote:

I guess you are safe for a while.

I have procedure 4410 lines and 149470 characters.

It compiles slow but works fine every day.

At 27 MAR 2010 10:43AM Bob Carten wrote:

There is no limit to the size of the source code for a stored procedure, but there is a limit to the size of the compiled code. Compiled code cannot exceed 64k or so.

View this thread on the Works forum...