I want to know if there are maintenance scripts or anything you can do to make a large composer installation perform better, and also discuss composer performance overall. First of all it can take quite a while from when you click "Composer edit on page" until you can start editing. I'm sure this depends on many things, but I was curious and ran SQL Profiler just to see what happens in the DB and when editing on of our pages the stored procedure "netPageDataLoadVersion" was called about 1800 times! From when the user clicked until he/she could edit. This seems crazy to me...?
Have you read this blog post http://krompaco.nu/2013/02/analyzing-sql-server-database-size/? Especially about uiMaxVersions.