Re: Problem: libpq, network traffic, memory usage - Mailing list pgsql-general

From Alexander Scholz
Subject Re: Problem: libpq, network traffic, memory usage
Date
Msg-id dn77n7$1lfu$1@news.hub.org
Whole thread Raw
In response to Re: Problem: libpq, network traffic, memory usage  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: Problem: libpq, network traffic, memory usage
List pgsql-general
Hi Andreas,

> The same question was yesterday on [pgsql-de-allgemein] ;-)
Yes - I just found it. :-) But I don't know whether it is really the
same prob.

> You have selected _ALL_ records, you got all records. Thats the point.
I SELECTed them, that's right, but I didn't FETCHed them. I thought that
would be a difference. It's at least the way it works with MSSQL and
ODBC/OLEDB (that's where I am coming from...)

BTW: The ODBC driver for postgres has the same <sorry> flaw </sorry>.
The ODBC API provides a cursor model but the driver doesn't seem to
implement it, because the same libpq behaviour occurs.

Is there ANY driver (ODBC, OLEDB) around that uses the cursor model?

> You can use a CURSOR to walk through the result.
Sorry, but I don't know exactly how to do that, can you help me out? We
are working with a C++ library that uses PQExec(). I don't even get
pgAdmin III to display data fetched by a cursor. ->please refer to my
posting to Scott.

Thanx in advance,

Alexander

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: [pgsql-de-allgemein] Query SELECT * sehr langsam
Next
From: Alexander Scholz
Date:
Subject: Re: [pgsql-de-allgemein] Query SELECT * sehr langsam