Re: [INTERFACES] Access'97 and ODBC - Mailing list pgsql-interfaces

From Byron Nikolaidis
Subject Re: [INTERFACES] Access'97 and ODBC
Date
Msg-id 35472BAD.2BB5C74E@insightdist.com
Whole thread Raw
In response to Re: [INTERFACES] Access'97 and ODBC  ("Jose' Soares Da Silva" <sferac@bo.nettuno.it>)
Responses Re: [INTERFACES] Access'97 and ODBC
List pgsql-interfaces

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


pgsql-interfaces by date:

Previous
From: Peter Mount
Date:
Subject: RE: [INTERFACES] jdbc vs. odbc performance
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Revised proposal for libpq and FE/BE protocol changes