Slow in VB Grid with PG

From: "PG" <pg(at)newhonest(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Slow in VB Grid with PG
Date: 2002-03-05 01:22:46
Message-ID: 005401c1c3e4$41930b00$0201a8c0@newhonest.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2002-03-05 02:31:26 Re: Validating Whole Numbers
Previous Message Lee Harr 2002-03-05 00:57:50 Re: Migration problem - serial fields