Custom fields search performance

[Angie Radtke]

Hi Guys,

I am very glad that we have the custom fields  right now.
I have two different  websites with several thousand  of articles.
In one of these projects I have 8 fields per article in the other one
project only two.
In the project with the 8 fields the search is unfortunately not
useablel anymore because it is infinitely slow.
Unfortunately, I had no choice.  I have to remove the custom fields from
the Search-Plugin ( own plugin)
That's a pity.
In the project with the two fields, the search is slow, but still usable.
Would the search be faster if the fields will have their own
search-plugin, or is that a structural problem?

Thanks Angie

[Niels Braczek]

Am 27.11.2017 um 16:07 schrieb Angie Radtke:

> In the project with the 8 fields the search is unfortunately not
> useablel anymore because it is infinitely slow.

I can confirm that observation.

> Would the search be faster if the fields will have their own
> search-plugin, or is that a structural problem?

The search within the custom fields should be separated (or optional),
so it at least can be turned off.

I'm not so much into database optimisation, so I can't tell if there's a
way to speed things up with all those joins.

Regards,
Niels

--
| New Stars on the Horizon: GreenCape · nibralab · laJoom |
| http://www.bsds.de · BSDS Braczek Software- und DatenSysteme |
| Webdesign · Webhosting · e-Commerce · Joomla! Content Management |
------------------------------------------------------------------

[yannick berges]

if you want a powerfull search and filtering i recommend you to test FLEXIcontent

[Allon Moritz]

There was a bug fixed in version 3.8.2 which should improve the performance. On which version are you working on? But I don't think it will improve the performance of search too.

[Angie Radtke]

Hi  Yannick

Am 28.11.2017 um 07:42 schrieb yannick berges:
> if you want a powerfull search and filtering i recommend you to test
> FLEXIcontent

This is no alternative, I think the problem should be fixed in the core,
because I'm not the only one with this issue.

Angie

[Angie Radtke]

Hi Allon,

we are on 3.8.2 . .-(

Maybe Niels is right with hint  to of all these joins?

Bye Angie

[Geraint Edwards]

Hi Angie

I have done a lot of work with Joomla Custom fields during the development of EasyLayouts and have found a very serious performance issue in the content search plugin and the way that is handles custom fields. It has a crippling effect on MySQL sites with more than a few hundred articles.

I found, in my tests, a search on a site with 4000 articles and 2 custom fields took as much as 20 minutes to execute but with my code changes it dropped to 0.3 seconds.

I have posted a PR which eliminates this performance hit - see https://github.com/joomla/joomla-cms/pull/18915

Hope it helps