Performance degraded in advanced search since FLEXIcontent v3.0 Beta7a

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

Advanced search is capable of searching FC fields and more: www.flexicontent.org/documentation/faq/7...a-custom-fields.html
Rooney

Hi Rooney,
Thank You for your link (this tutorial is perfect)
i have a lot of work with the migration of my site from an other CCK to FLEXIcontent (the really best CCK that i had never imagine)
I thought to a simple tutorial with simple example to explain differences between basic and advanced search.
I hope i will have soon enough time to share with the great community of FLEXIcontent what i understood (i take actually a lot of notes, i am a young student of FC )