Stored procedures aid both scalability and performance. They are stored in (and installed with) the FmLib database before the CML runs, and then called at run time. This aids performance because running logic in the database reduces the amount needed in the top two tiers, in particular the business-services tier.
For more information on CML-specific use of stored procedures, see Stored Procedures. Stored procedure code can be found under CML Stored Procedures.