This one is from DNN and Mitchel Sellers
http://www.dotnetnuke.com/Community...fault.aspx- thank you.
The main issue I see with the site log is this, the table is a "dual purpose" table it has indexes on the table for reporting, and it is a logging table. The issue here is that as the number of entries grows, the insertion cost grows as the indexes cause data to be re-organized.
This is why you will see growth of the table reduce performance.