At startup of our application, I get this error: SQL Anywhere Error -685: Resource governor for 'prepared statements' exceeded
Where can I limit these mentioned prepared statements?
asked 28 Sep '15, 10:39
By default, each connection is limited to 50 simultaneous prepared statements.
Ensure that your application is closing result sets and statements when it's done with them, so they don't continue to use resources on the server.
If you really need more then 50 simultaneous prepared statements, you can adjust the max_statement_count option.
answered 28 Sep '15, 10:55