Extremely Poor Performance with Custom Fields

[milhouse]

Hello all,

We have implemented Project Server with over 4000 users in the resource pool.

As this is an extremely large and varied organization we have allowed users
to retain local custom fields so that they can flavour their project
information as they require. We are currently experiencing horrible server
saving performance for project files that have local custom fields. File
saves and using Build Team from Enterprise on the Project Schedules is
excruciatingly slow.

Does the way in which Project Server saves a file change if the schedule has
local custom fields? The degradation in performance is astonishing with file
saves now taking in excess of 5-8 minutes for files with these custom fields.
Does anyone know of ways to optimize this? We have made the Enterprise
Global as small as possible with only a few views and tables in order to
increase the performance, but now, having done that, we are experiencing the
same, almost reciprocal problem, now that we have allowed users to use local
custom fields.

I haven't really gotten any information out of MS on this issue and would
really appreciate any insight or even an explanation on why this is happening.

Thanks,

Scot

 

[Peter]

am also experiencing pretty horrible performance. We have five custom fields,
but they just suck when you hit save.

Microsoft. what can we do?

 

[Peter]

Hi Scot, was wondering did you apply SP1... we're going to try that today to
see if that helps??

tx

P

 

[Gary L. Chefetz \(MVP\)]

I'm wondering what version of the software both of you are using. How does
anyone expect an answer to incomplete questions?

--

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

-

 

[Peter]

Hi Gary, sorry, fair point.

We are using Project Server 2003 with Sharepoint installed. Am about to
install SP1, and the Nov 20 Hotfix... and hope that this resolves our
issues...

tx

P