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.
Post Reply
danjde
Joomla! Intern
Joomla! Intern
Posts: 56
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!

Davide
http://www.cosmogonia.org - cosmogoniA
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

Post Reply

Return to “Performance - Joomla! 3.x”