Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group