note
erix
<p><blockquote><i>
For placeholders, here's my take.<br />
1. Efficiency? I doubt that you'd ever spot a difference
</i></blockquote>
<p>You may not spot a difference with a single query if processing time is less than a millisecond but when repeated, you do notice.
<p>On one local postgres server (version 15 beta 1), when I compare queries with placeholder versus hard-coded, the placeholder variant is consistently 2 to 3 times faster. (I think the main reason must be that the PREPARE needs only to run once.)
11142164
11142185