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

From: "Ansley, Michael" <Michael(dot)Ansley(at)intec(dot)co(dot)za>
To: "'Mengelbier, Magnus'" <Magnus(dot)Mengelbier(at)clinicaldatacare(dot)com>, "'Michael Doyle'" <relyod(at)co-operation-ireland(dot)ie>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: RE: [INTERFACES] Visual Basic interface (Help needed)
Date: 1999-09-29 11:28:34
Message-ID: 1BF7C7482189D211B03F00805F8527F748C0E0@S-NATH-EXCH2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(dot)Mengelbier(at)clinicaldatacare(dot)com]
>> Sent: Wednesday, September 29, 1999 1:05 PM
>> To: 'Michael Doyle'
>> Cc: 'Ansley, Michael'; pgsql-interfaces(at)postgreSQL(dot)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(dot)Ansley(at)intec(dot)co(dot)za]
>> > Sent: den 29 september 1999 12:24
>> > To: 'Michael Doyle'; pgsql-interfaces(at)postgreSQL(dot)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(at)co-operation-ireland(dot)ie]
>> > >> Sent: Wednesday, September 29, 1999 11:59 AM
>> > >> To: pgsql-interfaces(at)postgreSQL(dot)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(at)co-operation-ireland(dot)ie
>> > >> Network Administrator personal email:
>> relyod(at)indigo(dot)ie
>> > >> Co-operation Ireland http://www.co-operation-ireland.ie/
>> > >> Phone: +353-1-661 0588 Fax:
>> +353-1-661 8456
>> > >>
>> > >>
>> *********************************************************************
>> > >>
>> > >> ************
>> > >>
>> >
>> > ************
>>

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 1999-09-29 13:42:39 Re: [INTERFACES] psql trerminal behaviour
Previous Message Mengelbier, Magnus 1999-09-29 11:04:35 RE: [INTERFACES] Visual Basic interface (Help needed)