Affects Version/s: 6.1.30 EE GA3, 6.1.X EE, 6.2.10 EE GA1, 6.2.X EE
Component/s: Web Content > Web Content Administration
1. Create 2,000 web contents with 20,000+ characters
2. Go to Control Panel -> Web Content
3. Search for test
RESULT: Search will take 30 seconds.
thread dump shows that JournalArticleFinderImpl.doCountByC_G_C_A_V_T_D_C_T_S_T_D_S_ is the slow method.
this is because of the volume of the column "content" being searched. If "content" is removed from the query, it returns results in less than 1 second.
Searching content should be optional through the advanced search and should not be done through the keyword search since those searches should be done through the index and not the DB.
setting a property to allow content searches would enable the end user to prefer more results or faster queries based on their business needs.