Be Excellent To Each Other

Hiya.

Anyone here use Sharepoint? I know that Plissken does...

Anyway. We have a list that regularly grows via an automated process. It has recently reached 5000 entries, and now it doesn't work properly. It assigns incorrect permissions to list items, doesn't always create them properly, etc.

Is this a common problem? Is there no simple solution? My feeble internet searches seem to have confirmed that there is an issue with having a single list grow over 5000 items, so are we boned?

One solution would be to split the data into three separate lists, one each for data from 2007, 2008 and 2009. This is plausible, but I was wondering if there were other solutions available.

Cheers, peeps!

turn it off and on again.

Just off to yosemite for a couple of days.

Yeah I ran into this last year - the recommended solution is to limit each list container so it contains a max of 2000 entries. However, you have to ask yourself just how usable a list that big is - not very is the answer, so we spent a good deal of time re-organising so that each container contained a max of about 20 items. In you scenario you could break things down by year and than by month/week/financial period or whatever.

The limit in MOSS 2007/WSS 3.0 is 2000 items in a single view. The list can be a million items if you want, but the view onto the list is limited to 2000.

So, if you set up a view each for 2007, 2008, 2009 etc you should be able to cope. Even putting them into folders within the single list would do the trick, as the view onto the folder would come under the 2000 limit.