Performance issues caused by the SpammedPages feature

[ChiuchiuSorin]

When opening the Admin Tools Pro application, due to high processing cost from HQL query, it may cause a very long loading time of the main page or even cause the instance to run out of memory.

[ChiuchiuSorin]

Replace the spammed pages HQL query to solr to improve performance.
To be able to view the spammed pages, a reindexing of the entire wiki farm must be performed. For this, an admin must go to the search section in administration and perform a reindexing on the solr search engine:

The modal remains the same and can be found in the Instance usage section -> Specific stats -> View pages with over {n} comments, where n is the number of comments for a page to be considered spammed, which can be configured in Administration page: