Thread: RE: [INTERFACES] Visual Basic interface (Help needed)

RE: [INTERFACES] Visual Basic interface (Help needed)

From
"Ansley, Michael"
Date:
Absolutely.  This can be augmented by a slight shift in the design method
that you use.  Instead of creating data-orientated objects, you create
process-orientated (stateless) objects, which then utilize optimized
server-side processes, speeding up the whole process.

MikeA

>> -----Original Message-----
>> From: Mengelbier, Magnus 
>> [mailto:Magnus.Mengelbier@clinicaldatacare.com]
>> Sent: Wednesday, September 29, 1999 1:05 PM
>> To: 'Michael Doyle'
>> Cc: 'Ansley, Michael'; pgsql-interfaces@postgreSQL.org
>> Subject: RE: [INTERFACES] Visual Basic interface (Help needed)
>> 
>> 
>> 
>> You can optimize the connection further by taking a look how your
>> information is stored and the processing done in the VB 
>> interface.  You
>> could slim down the data traveling between the interface and 
>> database by
>> doing some preprocessing on the database end. My experience 
>> has found that
>> you can sometimes do more than half of the processing in 
>> database packages
>> and just show the results.
>> 
>> Magnus
>> 
>> > -----Original Message-----
>> > From:    Ansley, Michael [SMTP:Michael.Ansley@intec.co.za]
>> > Sent:     den 29 september 1999 12:24
>> > To:    'Michael Doyle'; pgsql-interfaces@postgreSQL.org
>> > Subject:    RE: [INTERFACES] Visual Basic interface (Help needed)
>> > 
>> > 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
>> > >> 
>> > >> 
>> *********************************************************************
>> > >> 
>> > >> ************
>> > >> 
>> > 
>> > ************
>>