-----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----- ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly