search

tpwd / ke_search

Search Extension for TYPO3 Content Management System, including faceting search functions.
https://extensions.typo3.org/extension/ke_search/
GNU General Public License v3.0
7 stars 31 forks source link

TYPO3 List view in backend is becoming slow #190

Closed DanielSiepmann closed 10 months ago

DanielSiepmann commented 10 months ago

This is when table tx_kesearch_stat_word is filled. The table has no index on pid. That results in slow sql queries whenever a page is opened in list view.

One can say this is an issue of TYPO3, not adding the index for all tables. But right now it is easier to fix that within EXT:ke_search.

I'll provide a PR soon.

DanielSiepmann commented 10 months ago

I've opened an issue on TYPO3: https://forge.typo3.org/issues/102179

christianbltr commented 10 months ago

Thanks. In https://forge.typo3.org/issues/102179 it is proposed to let TYPO3 auto-generate the indexes, but the table tx_kesearch_stat_word does not have a TCA definition so that would not work here. So the index for pid for needs to be added in the ext_tables.sql file.

DanielSiepmann commented 10 months ago

You're right. The project we have inherited has TCA for that table. So the extension itself should not be slow, it is an issue with the instance. TYPO3 otherwise would not create the queries. So the TYPO3 issue should have solved the issue.