>Would performance suffer that much? I have not benchmarked it much, however, the driver sends "autosave" queries once (savepoint) or twice(savepoint+release) for every user-provided query. If we use extended queries (parse+bind+exec) for every savepoint, that would result in 3 or 6 messages overhead for every user query.
>From many measurements we know that insert into table(id, name) values(?,?),(?,?),(?,?) is much more efficient than sending individual bind-exec-bind-exec-bind-exec-sync messages like "insert into table(id, name) values(?,?)" For instance, here are some measurements: https://www.baeldung.com/spring-jdbc-batch-inserts#performance-comparisons Based on that measurements I assume there's a non-trivial per-message overhead. Vladimir
