From: Byron Nikolaidis <byronn@insightdist.com>
To: Sbragion Denis <infotecn@tin.it>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Access'97 and ODBC
Date: Wed, 29 Apr 1998 09:31:25 -0400
Message-ID: <35472BAD.2BB5C74E@insightdist.com> (raw)
References: <Pine.LNX.3.96.980427141308.1975A-100000@proxy.bazzanese.com>
<3545ECD6.5615904D@sid.trust.ee>
<3.0.5.32.19980429090507.007f5ea0@MBox.InfoTecna.com>
Sbragion Denis wrote:
> P.S. I tested the new ODBC driver with index support. VisData still isn't
> able to show the index list, anyway it sees them because it allow updates.
> Used with VB the ODBC is rather slow compared with other ODBC (About 10
> time slower than MS SQL and Velocis, about 30 times slower than MySql) but
> it works pretty well. Anyway it is about 3/4 times faster than the OpenLink
> driver, which is also pretty buggy ;) Really good job Byron !
>
I'm not sure why VisData still isn't able to show the index list. First of all,
I dont know what "VisData" is anyway! Perhaps you could use the odbc tracing
feature (through the 32 bit odbc administrator) and send the "sql.log" to me.
Make sure it is empty before you begin your session. This will really slow
things down by the way.
As for performance, the backend affects that equation greatly. You should see
what happens in Access when you are using unique indexes. Even with one keypart,
Access generates that infamous query we have been talking about (with all the
ANDs and ORs), which really slows things down.
Byron
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: byronn@insightdist.com, infotecn@tin.it
Subject: Re: [INTERFACES] Access'97 and ODBC
In-Reply-To: <35472BAD.2BB5C74E@insightdist.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