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