Re: poor performance on ACCESS 97 client/oracle 7.3 server application
Date: Wed, 16 Jun 1999 16:37:48 -0400
Message-ID: <37680B1B.84EE5CA4_at_pilot.msu.edu>
Are you attaching tables and then running queries on those attached tables or are you using passthrough queries? If you are attaching tables and querying them, then your using Jet as your DB engine which is very slow compared to Oracle or SQL Server.
Bernd Rosenau wrote:
> Hi,
>
> our ACCESS 97 client/oracle 7.3 application has poor performance
> despite ORACLE running on a powerfull unix machine with lots of memory
> (several hundred MB !)
>
> The machines on the client side are also very well equiped
> (400 MHZ Pentium II machines with 128 MB of RAM)
>
> Very little data is stored in tables (less than 1000 rows in each
> table !!)
>
> Could it be the case that the NETWARE client installed on these
> machines slows database access down ?
>
> We had a simliar effect at a different client where our ACCESS 97 app
> is run with SQL Server at back end.
>
> Many thanks in advance for your help,
>
> Cheers, Bernd.
>
>
Received on Wed Jun 16 1999 - 22:37:48 CEST