The performance of your site can very quickly deteriorate if you are using a non bucket content structure and either the number of items in a folder bloats or the number of versions of an item bloats.
For a bit more reading on the number of items per folder see: Large number of Sitecore items per folder
These sql scripts allow you to quickly find the number of these offenders:
Children in a folder
|
1 2 3 4 5 6 7 |
SELECT TOP 1000 ParentID, COUNT(*) AS Total, (SELECT Name FROM [dbo].[Items] J WHERE J.ID = I.ParentID) AS Name FROM [dbo].[Items] I GROUP BY ParentID ORDER BY Total DESC |
Versions of an item
|
1 2 3 4 5 6 7 8 |
SELECT COUNT(DISTINCT Version) AS VersionCount, Language , ItemID, (SELECT Name FROM [dbo].[Items] WHERE ID = VF.ItemId) AS Name FROM VersionedFields VF GROUP BY ItemID, Language ORDER BY VersionCount DESC |