Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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
>> > >> 
>> > >> 
>> *********************************************************************
>> > >> 
>> > >> ************
>> > >> 
>> > 
>> > ************
>> 

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group