Re: Problem: libpq, network traffic, memory usage

Поиск
Список
Период
Сортировка
От Alexander Scholz
Тема Re: Problem: libpq, network traffic, memory usage
Дата
Msg-id dn77n7$1lfu$1@news.hub.org
обсуждение исходный текст
Ответ на Re: Problem: libpq, network traffic, memory usage  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Ответы Re: Problem: libpq, network traffic, memory usage  (Volkan YAZICI <yazicivo@ttnet.net.tr>)
Список 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 по дате отправления:

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: [pgsql-de-allgemein] Query SELECT * sehr langsam
Следующее
От: Alexander Scholz
Дата:
Сообщение: Re: [pgsql-de-allgemein] Query SELECT * sehr langsam