Message-ID: <gh-postgresql-interfaces-psqlodbc-88-c2648320169@github.com>
From: "abhi-555 (@abhi-555)" <noreply+abhi-555@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Mon, 10 Feb 2025 15:11:57 +0000
Subject: Re: [postgresql-interfaces/psqlodbc] issue #88: Poor performance of psqlodbc while executing ODBC array operations from TPCC load
In-Reply-To: <gh-postgresql-interfaces-psqlodbc-88@github.com>
References: <gh-postgresql-interfaces-psqlodbc-88@github.com>
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Login: abhi-555
X-GitHub-Comment-Id: 2648320169
X-GitHub-Comment-Type: issue_comment
X-GitHub-Edited-At: 2025-02-10T15:17:50Z
X-GitHub-Issue: 88
X-GitHub-Repo: postgresql-interfaces/psqlodbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/88#issuecomment-2648320169
Content-Type: text/plain; charset=utf-8

[Standalones.zip](https://github.com/user-attachments/files/18735771/Standalones.zip)

I have attached a standalone for batch_insert and batch_update in Standalones.zip . We are using these to detect the time taken and rate of records processed during batch insert and update simultaneously. The DDL of the table used is present in the CPP files.

We have the below summary where we have performed a comparison between the psqlodbc driver and a third party postgres driver. We are seeing significantly lower rates of processing in batch insert and update using psqlodbc driver. 

Summary of comparison

Records per batch 10000
Number of batches 1

Insert Rates
psqlodbc driver : 46190.0 records/sec
third party postgres driver : 163041.5 records/sec

Update Rates
psqlodbc driver : 26060.5 records/sec
third party postgres driver : 59786.5 records/sec

Would request you to provide us some fix which can help improve this performance