Poor Performance Linking to Oracle Backend

S

stara

Hi,

Currently we have Microsoft Access database with tables linked to Oracle
views. However with certain queries, it takes about 9 hours to run. The
linked tables have about half- million records. The query uses linked table
and few local tables. I'm not sure how to improve performance. I even tried
ADP. I tried to use ADO programming to link to Oracle back-end. But still the
performance is bad.

Could you please suggest ideas?

Thanks a lot,
Stara
 
N

Norman Yuan

This NG is about MS Access ADP, which can only use SQL Server/MSDE as back
end, no linked table, or other type of back end (thta is, you cannot try ADP
wirh Oracle back end). You need to post to other NG, such as

microsoft.public.access
microsoft.public.access.odbcclientsvr
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Poor performance running queries with tables linked to Oracle Back 4
migration performance question 8
Performance question? 3
Access 2007 linked to Oracle 3
Backend performance 2000 vs 2007 3
Access Front End - Oracle Backend - Multi User Logon Help! 1
Linking Oracle Tables in MS Access using ADO through VB programmin 6
Using ADO in an mdb application 106

Top