WL#3413: Stored Procedures: Compiler
Affects: 7.1 — Status: Un-Assigned — Priority: Very High
Compile stored procedures. One established way to do this is to translate SQL procedural statements to valid statements in some other language (such as C), write to a file, call the compiler for the other language, save a reference to the resultant object file in mysql.proc, and call it whenever CALL happens. The result should be an increase in speed, but you need that compiler.
Copyright (c) 2000, 2018, Oracle Corporation and/or its affiliates. All rights reserved.