Advertisement

finder

General questions relating to Joomla! 4.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
mernst
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Sun Sep 14, 2014 12:01 pm

finder

Post by mernst » Sat Nov 02, 2024 8:11 am

I have a site with 43305 articles on my joomla 4 site. Table bpp16_content has 106 MB. But if I use smart search indexing then table bpp16_finder_links_terms has 10 million records and 747 MB and table bpp16_finder_links has 43305 records 740 MB. In total, my database has grown to 2.2 GB which is not enough for many servers. What to do? Why is so much data being indexed? Isn't it some kind of bug?

Advertisement
User avatar
Pnkr
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 190
Joined: Thu Sep 01, 2011 7:26 am
Location: Athens, Greece

Re: finder

Post by Pnkr » Sat Nov 02, 2024 9:52 am

There are settings in the finder component where you can set the strength of the finder index.
For such a large content though, I would suggest going on separate search solution such as algolia etc.

User avatar
sakiss
Joomla! Explorer
Joomla! Explorer
Posts: 377
Joined: Wed Aug 20, 2008 4:09 pm

Re: finder

Post by sakiss » Mon Nov 04, 2024 12:30 pm

Try disabling the "Search For Phrases" setting.
This can increase your table size more than 20x.
Also its label is misleading. SS searches for phrases (i.e. sentences) with that disabled.

Advertisement

Post Reply

Return to “General Questions/New to Joomla! 4.x”