Limiting the Number of Statements

Set the MAX_STATEMENT_COUNT option to limit the number of prepared statements for a connection can make.

The MAX_STATEMENT_COUNT option limits the maximum number of prepared statements that a connection can use at once. If a server needs to support more than the default number (50) of prepared statements at any one time for any one connection, then you can set the MAX_STATEMENT_COUNT option to a higher value.

Related concepts
Optimizing for Typical Usage
Optimizing for Large Numbers of Users
Restricting Concurrent Queries
Limiting Query Temp Space
Limiting Queries by Rows Returned
Forcing Cursors to be Non-Scrolling
Limiting the Number of Cursors
Prefetching Cache Pages
Controlling the Number of Prefetched Rows
Controlling File System Buffering
Optimizing the Cache Partitions