If you look in the pg 7.3 docs it seems to state that FETCH can fetch
backwards. Does this mean that the backend needs to materialize the whole
recordset but could return just the last n records to the client? If so
then that would be different than the current psqlODBC state of affairs and
would be a net gain as it would reduce network traffic.
Any thoughts?
Ben
>From: Mike Mascari <mascarm@mascari.com>
>To: Ben Trewern <ben_trewern@hotmail.com>
>CC: pgsql-odbc@postgresql.org
>Subject: Re: [ODBC] FUD!! ODBC will not be supported by Microsoft in the
>future
>Date: Wed, 01 Oct 2003 10:43:56 -0400
>
>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
>
>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
_________________________________________________________________
Tired of 56k? Get a FREE BT Broadband connection
http://www.msn.co.uk/specials/btbroadband
