Обсуждение: Re: FUD!! ODBC will not be supported by Microsoft in the future

All

I've been using (or trying to use) the pgODBC driver with 'Use
Declare/Fetch' set to true and all goes well till you try to go to the end
of a large recordset.  The driver seems to load all the records instead of
just the last 50 (or whatever).  I'm using Delphi 7, BDE and psqlODBC
version 7.03.01.08 to connect to Postgres 7.3.1.

Any ideas?  Could this be a BDE problem?  Any one else out there using this
configuration?

Regards,

Ben

>From: Mike Mascari <mascarm@mascari.com>
>To: Stephen Frost <sfrost@snowman.net>
>CC: markw@mohawksoft.com, slutz@alacritude.com,pgsql-odbc@postgresql.org
>Subject: Re: [ODBC] FUD!! ODBC will not be supported by Microsoft in the
>future
>Date: Wed, 01 Oct 2003 08:39:31 -0400
>
>Stephen Frost wrote:
>
> > * markw@mohawksoft.com (markw@mohawksoft.com) wrote:
>
> >>That is not a PostgreSQL ODBC issue. There is a setting, I forget the
> >>name, that enables a cursor in the query.
> >
> > It should be on by default then, and I didn't see that option when I was
> > looking, can you tell me where it is?
>
>Nothin' like RTFM:
>
>http://gborg.postgresql.org/project/psqlodbc/genpage.php?doc-config
>
> >>On a side not, you will be hard pressed to find a commercial ODBC
> >>application, i.e. Access, that can handle large tables.
> >
> > Uh, Access and Oracle ODBC works just fine on the same table that
> > Postgres ODBC grinds the machine to a halt on.
>
>Use Declare/Fetch
>
> >>For what its worth, I use the PGODBC driver to create an index of tables
> >>with Millions of rows.
> >
> > I tried using the postgres ODBC driver to open a table with a couple
> > million rows.  It ran the client machine out of memory.  Same table w/
> > the Oracle ODBC driver worked just fine.
>
>Use Declare/Fetch
>
>HTH,
>
>Mike Mascari
>mascarm@mascari.com
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings

_________________________________________________________________
Express yourself with cool emoticons - download MSN Messenger today!
http://www.msn.co.uk/messenger

Ben Trewern wrote:

> All
>
> I've been using (or trying to use) the pgODBC driver with 'Use
> Declare/Fetch' set to true and all goes well till you try to go to the
> end of a large recordset.  The driver seems to load all the records
> instead of just the last 50 (or whatever).  I'm using Delphi 7, BDE and
> psqlODBC version 7.03.01.08 to connect to Postgres 7.3.1.
>
> Any ideas?  Could this be a BDE problem?  Any one else out there using
> this configuration?
>
> Regards,
>
> Ben

According to what I gather from the thread here:


http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&frame=right&th=7159b632785c579f&seekm=3E1BEFFE.88B57516%40tpf.co.jp#link13

PostgreSQL cannot perform a backward-scan and is forced to materialize
 the result set in its entirety. So that is a backend issue
specifically, not an ODBC issue, I'm afraid.

Mike Mascari
mascarm@mascari.com