I've got a SharePoint 2007 site which is using list item workflows to direct the execution of a business process. The list items are large (100+ fields). These workflows create tasks to collect data from various assigned users. The idea is that each step populates another piece of the original list item.
Most workflows start by checking the list item, and waiting for some condition before running through it's various data collection steps.
The problem is, each item has, upon creation, 26 workflows running at once. Over time, the workflows become completed and stop, of course, but it's clear that with only a few list items, there are a lot of workflows running on the site.
Question: Is there a better way to progressively collect this data than having all of these concurrently running workflows?
