Access ODBC link effect on system performance
Posted on 2007-04-04
I have been working on a accounting system with web front end which runs on Oracle database 4.5GB in size. The web front end restricts only 5000 lines of data to be exported to CSV from a query on the web tool. I set up an ODBC link through an access database linking ALL items table in the oracle database. From this link table, i created a make table query in ACCESS to produce + filter the data set i need. Coinciding with my actions, users of the web tool reported the web front end was becoming v slow and unable toi use.
Q:Having created the ODBC link table- would this affect overall system preformance. Slow it down?
Q:Opening the ODBC link table itself only - would slow system perfomance?
Q: ODBC has no effect?