Slow project opening from Oracle DB via ODBC

[Knijn]

I want to store my projects on a remote Oracle DB, via ODBC. Problem: the DB
already contains a lot of tables and data, and opening a project via the ODBC
link is very very slow.

SQL tracing shows that MSProject is performing multiple costly SELECT
queries when opening the project. It's about 20 of these queries, each taking
almost half a minute to complete. The query selects on the ALL_OBJECTS and
ALL_SYNONYMS tables from the Oracle DB, that contain hundreds of thousands of
records, causing the slowdown.

Does anybody know of a workaround? How can I tell MS Project to avoid these
queries? Any other ideas?

 

[Rod Gill]

The only thing I know of is to make sure you have the latest oracle ODBC
drivers. Try ones from Oracle and Micrcrosoft. Other than that you can't do
anything. A remote database may have latency as well which could slow things
down? If so running on Terminal Services or Citrix might help.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx