You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by William Kemper <do...@gmail.com> on 2015/07/28 23:38:39 UTC

Are there any performance considerations when using placeholders '?' in SQL statements?

Will ignite skip query parsing/planning for SQL statements using '?'
placeholders? Is there a statement cache that needs tuning? We've been
burned by the oracle driver's statement cache in the past.

Re: Are there any performance considerations when using placeholders '?' in SQL statements?

Posted by Sergi Vladykin <se...@gmail.com>.

Currently we do not cache parsed statements, but I think we will in the
future, so using placeholders instead of literals is preferable.
BTW, parsing of a query with placeholders must be a bit faster than parsing
of a query with literals.

Sergi


2015-07-29 0:38 GMT+03:00 William Kemper <do...@gmail.com>:

> Will ignite skip query parsing/planning for SQL statements using '?'
> placeholders? Is there a statement cache that needs tuning? We've been
> burned by the oracle driver's statement cache in the past.
>