Re: C++ Access 8 and Oracle ?

From: Tom Davies <tom_at_netspace.net.au>
Date: Tue, 10 Nov 1998 22:28:28 +1100
Message-ID: <72989o$kjj$1@otis.netspace.net.au>

gerard wrote in message <363E28F7.512F_at_xsoft.demon.co.uk>...
>Hope someone can help with this.
>
>A visual C++ program uses DAO an reads 90,000+ rows from an
>Access table and dumps them into a CSV file in about 10 minutes. The
>same program takes 3 hours to do the same job from a table linked
>through ODBC to an Oracle 8 database.
>
>There seems to be so many ways in DAO to do the same job so
>has anyone any idea how to speed this up ?
>
>Regards Gerard

Try Oracle Objects for OLE. This has a native interface.
If you don't mind changing the program, use ESQL/C.

Tom Received on Tue Nov 10 1998 - 05:28:28 CST