finder_term occupies 70% of the entire DB

Discussion regarding Joomla! 3.x Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Joomla! Intern
Joomla! Intern
Posts: 96
Joined: Mon Dec 28, 2009 1:48 pm

finder_term occupies 70% of the entire DB

Post by danjde » Sat Mar 10, 2018 9:18 am

Hello friends,
in a events web site (with daily new content), checking the tables I find out that the "finder_term" occupies almost the entire database.

Looking into the table content I find that at least 50% of these are repeated, are duplicated.
The Smart Search plugin is disabled (and I do not want to enable it), I was wondering if there is a way to eliminate at least the duplicate entries.

Furthermore the terms that I see in the DB, if I search through 'Components -> Search Engine' are not present on finder_term table . For what reason? The 'finder_term' are only collected by Smart Search engine?

Could it be necessary to perform a new indexing always from 'Components -> Search Engine' or it is useless? And for so , eventually should the tables be emptied first?

Thank you so much for your kind help!

n o p r o v a r e n o f a r e o n o n f a r e n o n c e p r o v a r e


Return to “Performance - Joomla! 3.x”