Slow in VB Grid with PG

Hi,

I'm answering my own question :

My original connection string looks like this:

Cnn.ConnectionString = "Provider=MSDASQL.1;Persist Security
Info=False;Extended Properties='DRIVER=
{PostgreSQL};DATABASE=test;SERVER=127.0.0.1;PORT=5432;UID=postgres;READONLY=
0;
PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES
=0
;CONNSETTINGS=;FETCH=100;SOCKET=4096;UNKNOWNSIZES=0;MAXVARCHARSIZE=254;MAXLO
NG
VARCHARSIZE=8190;DEBUG=0;COMMLOG=0;OPTIMIZER=1;KSQO=1;USEDECLAREFETCH=0;TEXT
AS
LONGVARCHAR=1;UNKNOWNSASLONGVARCHAR=0;BOOLSASCHAR=1;PARSE=0;CANCELASFREESTMT
=0
;EXTRASYSTABLEPREFIXES=dd_'"

The I changed the "USEDECLAREFETCH" from 0 to 1, and the speed goes up as
well as the recordsets are updatable.

By the way, what is "USEDECLAREFETCH"? What will it affect? Where can I find
info about those parameters?

==
====
Best Regards
Jason Kwok
==============
====
----- Original Message -----
From: "PG" <pg@newhonest.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, March 05, 2002 9:22 AM
Subject: [GENERAL] Slow in VB Grid with PG

Hi,

I have a problem with VB + PG thru ODBC.
When I do following, the speed is excellent :

--Code 1--
cmd.commandtext = "select * from table1 where parentid = '1234' "
set rst = cmd.execute
set datagrid1.datasource = rst
--End code 1--
But the grid is readonly.

--Code 2--
rst.open "select * from table1 where parentid = '1234' ", cnn, .....
set datagrid1.datasource = rst
---End Code 2 ---
This grid works fine, but extremely slow (more than 10 times slower than
code 1)

Is there a better way of manipulating grid with a better performance?

(I have only shown very little code here to avoid complexity. If it is not
enough, I'll send more)

==
====
Best Regards
Jason Kwok
==============
====

---
Virus Free
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.325 / Virus Database: 182 - Release Date: 2002/2/19

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

---
Virus Free
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2002/2/28