RE: slow odbc access....

> -----Original Message-----
> From: Sanjay Arora [mailto:sk(at)pobox(dot)com]
> Sent: 28 November 2000 23:34
> To: pgsql-interfaces(at)postgresql(dot)org
> Subject: [INTERFACES] slow odbc access....
>
>
> I am using postgreSQL v. 7.0.2 on RH Linux 6.2 on the server with VB6
> Application accessing the DB through postgrSQL ODBC driver v.
> 6.50 on a 10
> mbps ethernet network using four eight port cascaded hubs. PG
> is recompiled
> with BLCKSZ 32 kb.

Try to use ADO to access the database rather than DAO or RDO as it's much
quicker. Make sure you use ForwardOnly recordsets wherever possible and only
use Dynamic if you absolutely have to.

Another thing to remember - Jet is evil don't let it anywhere near your
project if you can help it!!

HTH, regards,
Dave.