zio-sql icon indicating copy to clipboard operation
zio-sql copied to clipboard
verified publisher icon zio

Support Prepared Statements

Open jdegoes opened this issue 5 years ago • 1 comments

Parameterized queries can offer higher performance.

jdegoes avatar May 19 '20 12:05 jdegoes

We need to have a conversation about this. Prepared Statements can offer higher performance but as I understand it's not always the case (... research needed).

Some thoughts:

  1. Do we switch to Prepared Statements completely or do offer a choice?
  2. If we offer a choice, then is it a choice per statement or application-wide (then it comes down to choosing the renderer implementation at the layer level)
  3. Prepared statements could go via zio-jdbc (AFAIK it's using Prepared Statements)

I suppose more research is needed. What is the actual gain with Prepared Statements and what is the competition doing?

jczuchnowski avatar Apr 28 '22 21:04 jczuchnowski