Performance degraded in advanced search since FLEXIcontent v3.0 Beta7a

Hi,
i'm testing FLEXIcontent v3.0.
I saw something strange since v3.0 Beta7a (v3.0 Beta7c also).
When you search with the advanced search plugin something happend if you search a word that give a lot of ankswer.
Example 1 : i'm searching the word "uncommon_word" : that match with not much item . All is all right
Example 2 : i'm searching the word "frequent_word" : that match with many item (100 for example) . Then the Query does not finish and the site is out during 5 minutes

I can't understand and find where is the mistake in the new code

Hello

please send a PM, with
- super admin access
- and detailed steps to follow to see this
frontend page URL
word(s) that you used
menu item ID that you are using

Hi Georgios,
I'm working in Joomla (mambo) since ten years
i used other cck since five years
i use and test FLEXIcontent since 3 weeks and i am crazy like a child in christmas with your marvelous component.
i am verry happy that you look at this. Your work on FLEXIcontent is simply fabulous.
I sent you a private message.
Charly

thanks think to post a review on jed !

Hi Micker,
I am preparing my review.
So many goog things to present to the Joomla Community about FLEXIcontent...

we try to do more pub ... lol

Hello

yes i now remember a change

-- if some words is too common , we will do ... LIKE word% search which is very very slow, compared to the very fast index based search

but i am not sure if that was really commited,
will check / compare search queries of v3 BETA6b and BETA7x

indeed the performance difference in search view is too big for the same searchword

Hello

-- your v3 BETA6b site is using BASIC Index,
-- your v3 BETA7x site is using ADVANCED Search Index.

-- you have 2 search menu items in your website
and we have a bug : the -default- search menu item in (component params / TAB: other views) is always used
... and the current menu item, e.g. the menu item you configured in the module is ignored

will fix

but ... also i had chance to optmize search queries
For common words ... found in almost 8.000 items

-- Advanced Search Index (the main/complex query)
before: 100 Seconds
after: just 38 ms

-- Basic Search Index (the main/complex query)
before: 64 ms
after: 17 ms


Advanced search index query for rare words:
< 1 ms !!

This is great

Hi Georgios,
Thank you so much for your investigations.
i must better understand differences between basic search and advanced search.
Thank for your perfect setting on my test site.
I will more study all this setting,
I will submit you new tutorials when i better understand the powerfull system of searching with FLEXIcontent.
Best regards.
Charly

yes if you want to particpate with tuto you are welcome