Dear All
My webpage interfaces to EPM 2003 to get status of projects and presents it in the form of Smileys on a webpage.
However, the interface is very slow. It takes more than a minute easily to get the data from EPM 2003. Please advise me how to optimize the speed
Background Information I have :
The 2003 Microsoft Project version employed ODBC to connect to the server, which is problematic over low bandwidth and high latency connections. This problem is often skirted by remotely using a PC with the same network (LAN) as the server.
The 2007 version leverages SOAP to access the server. Although this facilitates clients over low bandwidth / high latency connections, it adds a level of complexity (in the form of a Queue) that must be managed by an administrator. Specifically, a job in the queue could get stuck and block other jobs from completion.
Your help is greatly appreciated to improve the project performance