Microsoft Access Queries to an Oracle DB run 4 times slower in XP than Win98

[Sly]

Created a Microsoft Access query in MA 2002 SP2 which connects to
various tables in a very large Oracle database (5,000 tables). Access
is used for ad hoc reporting purposes.

When we upgraded from running Win98 to Windows XP Professional (ver
5.1.26 SP2) the queries times degraded significantly. Queries that
took 11 minutes now take 43 minutes or longer. Both machines have 512
RAM and have the same version of Microsoft access.

Win98 machine - Dell Optiplex computer
XP Professional - IBM model 8184 MU2
Microsoft Access - Access 2002 SP-2 on both Win98 and XP.

Any ideas on why the same queries run on the same version of Microsoft
Access would run so much slower on Xp than Win98 and what I can do to
correct would be greatly appreciated.

 

[NetworkTrade]

actually I was thinking in this scenario that one must use a PassThrough
query that is run at the Oracle machine rather than with Access.....

Definitely not an answer to your question ....just a comment...

 

[John Spencer]

Speculation on my part.

If Windows XP needs more RAM to run efficiently, there will be less RAM for
Access. It could be that the hard drive is a lot busier than it used to be as
virtual memory is being used on the hard drive.

That said, if it is possible, the solution might be to write a pass through
query that runs on ORACLE and returns the results you need.

If you can't do that you may be able to restructure your query and report.

Avoid calculations in the query and any local tables (if possible).

Do the calculations (if any) in controls and with vba in the report's section events.