pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Albert Cervera Areny <albertca@jazzfree.com>
To: pgsql-odbc@postgresql.org
To: pgsql-performance@postgresql.org
Subject: Bad performance using ODBC
Date: Wed, 16 Jul 2003 16:15:01 +0200
Message-ID: <200307161615.13989.albertca@jazzfree.com> (raw)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,
  I have a performance problem using postgresql when the connection is made 
via ODBC with a windows machine using the latests ODBC drivers (Windows) and 
PostgreSQL 7.3.3 (Linux).

  The queries made by my Visual Basic program are very very simple. It queries 
with as Select if a record exists and if so, it reduces stock with an Update. 
For the benchmarks I do it 200 times.

  If I test it against an Access database (located in a SMB server) it spends 
3 seconds but against PostgreSQL 17 !! Exactly the same test programmed in C 
(with pgsql libraries) and run within the same machine or another Linux 
spends less than a second!!

  So the problem seems to be whether with the ODBC drivers or with Windows 
ODBC itself. Are there any parameters in the ODBC drivers that might help 
reducing that big overhead added or do you have any suggestions to speed it 
up?

Thanks in advance!
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/FV3pTK7ZP4pDOHcRAmVWAJ9KF/YyKmuBZcidV3FK2gESaX25NwCgjABx
6WhA0HgC7oxF7VFJeczIrgE=
=3H+u
-----END PGP SIGNATURE-----



view thread (3+ messages)  latest in thread

Message-ID: <200307161615.13989.albertca@jazzfree.com>
Permalink:  ../200307161615.13989.albertca@jazzfree.com/
Also on:    postgresql.org/message-id/200307161615.13989.albertca@jazzfree.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: albertca@jazzfree.com, pgsql-odbc@postgresql.org
  Subject: Re: Bad performance using ODBC
  In-Reply-To: <200307161615.13989.albertca@jazzfree.com>
  References: <200307161615.13989.albertca@jazzfree.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox