Ben Trewern wrote:
> 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?
and
> 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
Well, looking at the ODBC sources shows that it is capable of using
DECLARE/FETCH to move to the end the record set. PostgreSQL will still
have to materialize the result set on the backend, of course. So I'd
suggest performing an ODBC trace to see which ODBC API functions are
being called on the client side and also turn logging on in
postgresql.conf to see what the queries look like on the server.
ODBC provides access to cursor operations through the use of
SQLFetch(), which is a forward-only cursor and SQLFetchScroll() which
is scroll-capable. Perhaps Delphi 7 is using SQLFetch() instead of
SQLFetchScroll()? The ODBC trace will tell.
Mike Mascari
mascarm@mascari.com
