SharePoint - Deleting Workflow History List

Asked By NestorCabrer on 04-Feb-09 10:22 AM
Greetings group,

My organization has recently read up on Sharepoint recommendations that
state for performance reasons List Items should be limited to 2,000 per list
(btw, my org seems to take this as an absolute limitation to Sharepoint, not
a recommendation).

As a result, we're looking at ways to limit or delete lists that have more
than 2,000 items.  I recently noticed that a list that has a Workflow
associated with it has a "Workflow History" List that has over 5,000 items!
My question is if it would be save to just delete this list (from the
Workflow History settings) or just to use the Auto purge feature.

Thanks in advance,


--
Nestor


stewoo replied on 04-Feb-09 12:25 PM
------=_NextPart_0001_45455D64
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Well that is a good number  to start with, but it is a recommendation and
not a hard limit.  The truth is that a list view's performance will degrade
quickly when you start getting 2000+ items in a single view.

You probably won't see that much of a difference between 2000 and 2001, but
the difference between 2000 and 3000 is much more noticeable than say 1000
to 2000 items.

Since the Workflow History list is a hidden list is only used by SharePoint
to hydrate and dehydrate workflows you will not see a perf hit from that
list (unless a lot people are viewing that list for some reason and since
there is no direct link anywhere in SharePoint they would have to "know"
where to look)

The list will clean itself up after 60+ days so I would just leave it
alone.  Removing items from that list could cause running workflows to not
complete correctly.


-Stephen

http://blogs.technet.com/stewood
------=_NextPart_0001_45455D64
Content-Type: text/x-rtf
Content-Transfer-Encoding: 7bit

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs20 Well that is a good number  to start with, but it is a recommendation and not a hard limit.  The truth is that a list view's performance will degrade quickly when you start getting 2000+ items in a single view.
\par
\par You probably won't see that much of a difference between 2000 and 2001, but the difference between 2000 and 3000 is much more noticeable than say 1000 to 2000 items.
\par
\par Since the Workflow History list is a hidden list is only used by SharePoint to hydrate and dehydrate workflows you will not see a perf hit from that list (unless a lot people are viewing that list for some reason and since there is no direct link anywhere in SharePoint they would have to "know" where to look)
\par
\par The list will clean itself up after 60+ days so I would just leave it alone.  Removing items from that list could cause running workflows to not complete correctly.
\par
\par
\par -Stephen
\par
\par http://blogs.technet.com/stewood
\par }
------=_NextPart_0001_45455D64--