Performance: How to disable keyword indexing in SP2
EPiServer CMS indexes content in properties for two purposes, one of them is to extract links and the other is to extract keywords for the internal search engine.
If you don’t use the internal search engine the server does a lot of work and fills up tables* in the database with a lot of keywords that are never used.
Since EPiServer CMS 5 R2 Service Pack 2 you can disable the keyword indexing by setting:
<site (..) indexingTextEnabled="false" (..) />
*) Affected tables in the database are tblKeyword and tblPageKeyword