X-Original-To: pgsql-odbc-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 87787CC625 for ; Wed, 16 Jul 2003 14:17:46 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 86100-04 for ; Wed, 16 Jul 2003 14:18:06 +0000 (GMT) Received: from albert.auore.net (197.Red-80-24-20.pooles.rima-tde.net [80.24.20.197]) by svr1.postgresql.org (Postfix) with SMTP id 4B11CCC64D for ; Wed, 16 Jul 2003 11:14:49 -0300 (ADT) Received: (qmail 2880 invoked by uid 1000); 16 Jul 2003 14:15:14 -0000 From: Albert Cervera Areny Reply-To: albertca@jazzfree.com To: pgsql-odbc@postgresql.org, pgsql-performance@postgresql.org Subject: Bad performance using ODBC Date: Wed, 16 Jul 2003 16:15:01 +0200 User-Agent: KMail/1.5.9 MIME-Version: 1.0 Content-Disposition: inline Content-Type: Text/Plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Message-Id: <200307161615.13989.albertca@jazzfree.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/36 X-Sequence-Number: 3097 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I have a performance problem using postgresql when the connection is made= =20 via ODBC with a windows machine using the latests ODBC drivers (Windows) an= d=20 PostgreSQL 7.3.3 (Linux). The queries made by my Visual Basic program are very very simple. It quer= ies=20 with as Select if a record exists and if so, it reduces stock with an Updat= e.=20 For the benchmarks I do it 200 times. If I test it against an Access database (located in a SMB server) it spen= ds=20 3 seconds but against PostgreSQL 17 !! Exactly the same test programmed in = C=20 (with pgsql libraries) and run within the same machine or another Linux=20 spends less than a second!! So the problem seems to be whether with the ODBC drivers or with Windows= =20 ODBC itself. Are there any parameters in the ODBC drivers that might help= =20 reducing that big overhead added or do you have any suggestions to speed it= =20 up? Thanks in advance! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/FV3pTK7ZP4pDOHcRAmVWAJ9KF/YyKmuBZcidV3FK2gESaX25NwCgjABx 6WhA0HgC7oxF7VFJeczIrgE=3D =3D3H+u -----END PGP SIGNATURE-----