Using Prepared Statements

If you are using an older version of SingleStoreDB Cloud, or using SingleStoreDB Cloud with Audit Logging enabled, server-side prepared statements are not supported. Instead, many client drivers support a configuration option to allow client-side prepared statements. This configuration option may also be referred to as client-side prepared statement emulation or parameter interpolation. You can use the same code in your application, but just change a flag in the client driver configuration. For example:

• In the MySQL Connector/J (JDBC) driver, set useServerPrepStmts=false, which is the default configuration https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html.

• In MariaDB Connector/J, set useServerPrepStmts=falsehttps://mariadb.com/kb/en/about-mariadb-connector-j/.

• In ODBC, set no_ssps=1https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html.

• In the Go MySQL driver, set interpolateParams=truehttps://github.com/go-sql-driver/mysql#interpolateparams.

• In PHP PDO, set PDO::ATTR_EMULATE_PREPARES=TRUEhttps://www.php.net/manual/en/pdo.setattribute.php.

In many other databases, server-side prepared statements provide performance advantages, but SingleStoreDB Cloud already compiles and caches query plans internally, so SingleStoreDB Cloud does not need server-side prepared statements to get most of those performance advantages.