On 4/16/20 4:59 PM, Ted Toth wrote:
On Thu, Apr 16, 2020 at 6:29 PM Ted Toth <[email protected] <mailto:[email protected]>> wrote:I've noticed that the first exec of an INSERT prepared statement takes ~5 time longer (I'm using libpq in C and wrapping the calls to time them) then subsequent exec's is this the expected behavior and if so is there any thing I can do to mitigate this affect? TedFor example (in my environment) I'm seeing the prepare take ~10ms, the first exec take ~30 ms and subsequent exec's take ~4 ms.
I don't have an answer. I believe though that to help those that might it would be helpful to show the actual code.
-- Adrian Klaver [email protected]
