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