Message-ID: <gh-postgresql-interfaces-psqlodbc-88@github.com>
From: "abhi-555 (@abhi-555)" <noreply+abhi-555@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Mon, 27 Jan 2025 10:37:23 +0000
Subject: [postgresql-interfaces/psqlodbc] issue #88: Poor performance of psqlodbc while executing ODBC array operations from TPCC load
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Id: 27189011
X-GitHub-Author-Login: abhi-555
X-GitHub-Issue: 88
X-GitHub-Repo: postgresql-interfaces/psqlodbc
X-GitHub-State: open
X-GitHub-Type: issue
X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/88
Content-Type: text/plain; charset=utf-8

We are trying to use psqlodbc to perform ODBC batch/array operations (the operations include a mix of insert, update and delete) using the standard benchmark Tpcc load. 

We are seeing a rate of 12000 records/sec getting processed, which is a very poor number. Is there any known connection option which needs to be set OR any other way which can help us speed this performance ?

Please let me know