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
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 |