From: Sbragion Denis <infotecn@tin.it>
To: byronn@insightdist.com
Cc: pgsql-interfaces@postgresql.org
Subject: New ODBC Driver: some tests.
Date: Mon, 11 May 1998 10:04:03 +0200
Message-ID: <3.0.5.32.19980511100403.0083c450@MBox.InfoTecna.com> (raw)
Hello,
I performed some quick test on the new driver. VisDATA is still unable to
retrieve the index list, anyway the driver's still working perfectly under
Visual Basic. There's a *huge* increase in the overall speed of the driver
which is now about 10 times faster than the previous one. With the "Use
cursor" checkbox disabled now it is even a little faster than MS Sql Server
(!) as long as there are only few (less than 2/3 thousand) row in the
tables used. With "Use cursor" enabled the driver is a bit slower (though
your previous e-mail stated that it should be faster) and it also sometimes
suffer the lock problem you were talking about. Anyway performances are
stable even with about 50.000 row in a table.
Great job Byron !
P.S. Visual basic sometimes (about once every 500 insert operations) reports:
3155:ODBC--insert on a linked table '???' failed.
Anyway I think this is a VB problem because:
1) There are no linked tables. I'm using ODBCDirect, not an Access database
with linked table in it.
2) It reports the same error, or a similar one, with all the driver I
tested in my life, including the MS ones.
Hope it helps.
Dr. Sbragion Denis
InfoTecna
Tel, Fax: +39 39 2324054
URL: http://space.tin.it/internet/dsbragio
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 using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: infotecn@tin.it, byronn@insightdist.com
Subject: Re: New ODBC Driver: some tests.
In-Reply-To: <3.0.5.32.19980511100403.0083c450@MBox.InfoTecna.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