Re: SQLExecute get result to client?

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Ludek Finstrle <xfinstrl(at)informatics(dot)muni(dot)cz>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: SQLExecute get result to client?
Date: 2002-01-27 23:46:19
Message-ID: 3C54914A.B8DEEBB@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Ludek Finstrle wrote:
>

[snip]

> There is difference between Postgres and MSSQL ODBC. Postgres load whole
> result to client in SQLExecute but MSSQL not. Table have +-500000 rows and
> transfer through net takes very long time.
>
> So my question is: Exists some patch to fix this? Or could you help me
> with basic information what I have to change?

Turn on the Use Declare/Fetch option.
It would work well with read-only applications.

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2002-01-28 00:36:02 Re: Connection Problem
Previous Message Ludek Finstrle 2002-01-27 21:47:06 SQLExecute get result to client?