Processing of queries is additionally optimized by a built-in statement cache.
Statement cache is an internal memory for storing a small number of previously prepared SQL statements. The statement cache operates in such a way that the prepare phase is omitted if the prepared statement is in the cache. If a connection is closed, the statement cache is purged.
In ODBC, the number of cached statements for a session can be set by using a client-side solid.ini configuration parameter Client.StatementCache.
In JDBC, the statement cache size can be dynamically set by using a non-standard StatementCache connection property.