Record limit in Project Server 2007 Lookup tables?

D

Don

Does anyone know if there is a limit to the number of records that will
display via the hierarchical lookup table via the drop down list in a custom
field in the Microsoft Project 2007 client application?

I had 44k records in there and the drop down list didn't work altogether.
Clicked the down arrow and nothign happened.

When I brought it down to 30k records, it worked fine.
 
P

Paul Conroy

AFAIK, there's no limit, other than the servers ability to manage this amount
of data effectiently. I would have thought that 30k + items in a custom
field would be unmanagable by the users.

What's hardware/architecture have you got PS deployed in ?

Out of interest, what are you using it for ?
 
D

Don

Thanks for the response.

Our development deployment for Project Server is on a Dual 1400 Mhz Pentium
III-S, 1 GB RAM, Win 2003 SP2.

Production, which hasn't been deployed yet, will be on a Quad 2.66 Ghz Intel
Xeon 5150, with 2 GB RAM, Win 2003 SP2.

We're going to need our users to select a Project Code/Task Code combination
from this custom field, which I have set up in a hierarchical lookup table.
Unfortunately, there are currently over 30k combinations in this table. I
was surprised to see that the drop down responded pretty well with 30k
records in it, and since it has an auto-lookup feature, having that many
records won't be a problem in terms of usability. What I'm worried about is
scaling up to 40 and 50k records in there over the next few years.

Do you think this might be a hardware issue?

I should probably get this set up on our production server, if for nothing
else than to rule that out.

Thanks in advance. I really appreciate the help.

Don
 
P

Paul Conroy

I would recommend increasing the RAM in both production and test and
implementing a 64bit solution which would give the ability to scale up easier.

Is your SQL server 64 bit ? If not, I'd seriously consider chaning it to x64.

If your running with a single server, I'd suggest placing it in a single
node NLB cluster so you can scale out as and when the need requires you to.

--http://paulconroy.blogspot.com/
 
D

Don

Hi Paul,

I ended up getting the same results after putting it on our production
server, a dual quad core with 4 GB of memory. Same results.

After some additional testing and a call in to MS Support, I've found that
there is a 32k record limit for lookup tables to display in the MS Project
custom field drop down lists.

Thanks again for your help. Looks like it'll be plan b for me!

Regards,
Don
 
Top