RE: [INTERFACES] Visual Basic interface (Help needed) - Mailing list pgsql-interfaces

From Ansley, Michael
Subject RE: [INTERFACES] Visual Basic interface (Help needed)
Date
Msg-id 1BF7C7482189D211B03F00805F8527F748C0DF@S-NATH-EXCH2
Whole thread Raw
List pgsql-interfaces
ADO should be the most responsive of the lot (DAO, RDO, ADO) over a slow
connection.  However, you need to make sure that you are doing it right,
including making use of the batch updatable, disconnected recordsets that
ADO offers.  This capability means that a connection to the database does
not have to be maintained between getting the data, and updating it.  Of
course, if you select half a million records, it's still going to be slow.
But if your queries are optimised properly, and your update processes take
the disconnected recordsets into account, you can run quite well over slow
links.  Also, try to ensure that your ODBC is configured optimally, which
may be different for disconnected recordsets than for connected ones.

MikeA

>> -----Original Message-----
>> From: Michael Doyle [mailto:relyod@co-operation-ireland.ie]
>> Sent: Wednesday, September 29, 1999 11:59 AM
>> To: pgsql-interfaces@postgreSQL.org
>> Subject: [INTERFACES] Visual Basic interface (Help needed)
>> 
>> 
>> I wonder if anyone can tell me what is the most efficient
>> way of accessing a PostgreSQL database (hosted on a FreeBSD server)
>> in a program written in Visual Basic ?
>> 
>> I am using Visual Basic 6 and the Postgres ODBC drivers
>> and have found that while accessing the database on the LAN is
>> fairly responsive, the remote sites (connected by 128k leased line)
>> have unacceptable response times.
>> 
>> I was using the ADO controls in VB6.
>> 
>> Are there any better controls? Should I try to use the standard DAO
>> controls with an ODBC data source ?
>> 
>> Any hints on this would be greatly appreciated
>> 
>> <>< ============================================================ ><>
>> Michael Doyle                    email: 
>> relyod@co-operation-ireland.ie
>> Network Administrator            personal email:    relyod@indigo.ie
>> Co-operation Ireland      http://www.co-operation-ireland.ie/
>> Phone: +353-1-661 0588                          Fax: +353-1-661 8456
>> 
>> *********************************************************************
>> 
>> ************
>> 


pgsql-interfaces by date:

Previous
From: Michael Doyle
Date:
Subject: Visual Basic interface (Help needed)
Next
From: "Mengelbier, Magnus"
Date:
Subject: RE: [INTERFACES] Visual Basic interface (Help needed)