Views take a long time to load

  • Thread starter Stephen Eyton-Jones
  • Start date
S

Stephen Eyton-Jones

I have a single project of about 4500 activities...fully loaded with resources etc. The installation includes a pretty good Server specifically setup as a views server, and currently this project is only one of about 5 in the database as we are just implementing, but we are talking about having 30 such projects, and perhaps thousands of smaller 100 activity projects in the server database. The issue we're seeing right now is that to switch views on the 4500 activitiy project takes anywhere between 60-90 seconds, even when filtered.

The question is..is this normal? This latency will not be acceptable to the users. Is there something that can be done to improve this performance. I've run Smoketest and the results there are great, but we're talking about some 145 activities in ths project.

Any ideas

Thanks
 
G

Gary L. Chefetz \(MVP\)

Stephen:

What have you done to isolate the bottleneck? Are the end user computers
maxing out? What version of MDAC do you have deployed in the organization?
What version of Project Server are you using? What is your hardware
configuration?

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-
Stephen Eyton-Jones said:
I have a single project of about 4500 activities...fully loaded with
Click to expand...
resources etc. The installation includes a pretty good Server specifically
setup as a views server, and currently this project is only one of about 5
in the database as we are just implementing, but we are talking about having
30 such projects, and perhaps thousands of smaller 100 activity projects in
the server database. The issue we're seeing right now is that to switch
views on the 4500 activitiy project takes anywhere between 60-90 seconds,
even when filtered.
The question is..is this normal? This latency will not be acceptable to
Click to expand...
the users. Is there something that can be done to improve this performance.
I've run Smoketest and the results there are great, but we're talking about
some 145 activities in ths project.
 
G

Gary L. Chefetz \(MVP\)

Stephen:

Start by upgrading to MDAC 2.8. The version you cite does not adequately
support the Project Server 2003 environment. Make sure you upgrade all
systems including workstations.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-
Stephen Eyton-Jones said:
At this point it is fairly easy to isolate the bottleneck as there are
Click to expand...
only 3 users using the project server system. According to the component
checker for MDAC I have MDAC 2.5 SP3. The version of MS Project is 2003.
Hardware is setup with a seperate view server, seperate SQL Server, and a
server for MS Project Server (I do not have actual specs at this time, but
the servers are all of 2 CPU with 1Gig of RAM). The client machines range,
but the one I'm working with is a P4 1Ghz with 256MB of RAM running Windows
2000.
 
Top