Re: ADO server side cursor sloooow

Bill Bach wrote:

> Nice. Did they give you a Bug Number for tracking purposes?

Apparently Pervasive does not consider it a bug. At least there was no
indication in my dialog with support that they consider it a bug.

>From my limited experience with Persavive to date it appears that the
ODBC driver is the only Win32 driver that they have spent much time
tuning and the only one they really support. Using ADO the OLE DB
provider is much slower than the ODBC driver (which should not be the
case).

The performance of the PDAC components is pretty good but they appear
to have a serious deployment problem. I just tried to deploy a program
compiled with the version 8.5 PDAC components at a site that is running
PSQL 8.1 and it will not connect. My client, who is a big enough
customer of Pervasives to get attention, had a conference call with the
senior people in product management and engineering and they did not
seem to consider that a bug either. Apparently they think it is quite
reasonable to have to have a different version of the program for every
version of PSQL you might have to deploy on. Thankfully no other
database vendor I know of has that attitude. :)

The other problem with PDAC is that the last version I can find is for
Delphi 7. Apparently they never produced a version for Delphi 2005. I
was just told by support, who was told by the product manager, that
there will not be an update for Borland Developer Studio 2006, which
shipped a month and a half ago, until mid-year at the earliest.
Needless to say we have abandoned PDAC.

--
..Bill.
.

Relevant Pages

  • RE: Protocol Error in TDS Stream vs Network Packet Size
    ... We reported this problem and finally we confirmed that it is a bug. ... For MSQuery, ODBC driver is used which has a problem in retrieving large ... the field definition for the recordset is too large to fit in one ...
    (microsoft.public.sqlserver.connect)
  • Re: MS SQL Server ODBC Driver hanging code when using multiple active statements and SQLGetData
    ... It would be nice if future versions of the SQL ODBC driver throw an exception. ... What I'll need is a knowledge base article or something that describes the bug, even if it points out that there is no solution to it. ... I have consulted with our product team members. ... will throw an exception instead of infinitely waiting. ...
    (microsoft.public.data.odbc)
  • Re: ODBC SQLColums is very slow
    ... They turned down an earlier request to upgrade the ODBC driver, which currently might very well be a release 9. ... Do you have some more input on that bug? ...
    (comp.databases.oracle.server)