Using Prepared Statements

If you are using an older version of SingleStore, or using SingleStore with Audit Logging enabled, SingleStore does not support server-side prepared statements. 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 change a flag in the client driver configuration. For example:

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

Last modified:

Was this article helpful?