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