Our LSW_SNAPSHOT table is at 88K rows...86K of those are unnamed snapshots. Which probably isn't a good thing...
If I single out a specific toolkit with 1100 entries in LSW_SNAPSHOT, I'm seeing CREATED_ON and LAST_MODIFIED in sequential rows (order by SEQ_NUM) all within the same second of each other. I pulled three rows in the same second and each entry contained one item. The sample I pulled were each Business Objects...
I might have been discovering a WSDL and importing the objects at the time...but does it sound right that an LSW_SNAPSHOT entry is being created so often?
We do not have any automatic snapshot clean-up currently enabled and we're researching the impacts to making this happen.