How slow is Use "search %word% " option?

More
9 years 4 months ago #55422 by wintercat
I'm using flexicontent 3beta7 and under "Lists:Filtering" tab in the Configuration there is this option "Use search %word% (slow !)".
Turned out my website needs this option to be turned on for flexicontent search to properly work and the site heavily relies on the search function.
My question is, how much will using this option slow down searching? Like 2x slower than without or can it be 10x slower?

Please Log in or Create an account to join the conversation.

More
9 years 4 months ago #55424 by micker
that depend number of item and number of field and your server performance
try it

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

More
9 years 4 months ago #55426 by ggppdk
Hello

first answer these
- does your website include asian languages without spaces or you want to overcome the limit for small words ?
- how much content (how many articles/items) does your website have ?

The performance penalty is if having more than 1,000 will be great (as the effect is linear with the number of content items that you have)

But for small website e.g. 100 items:
e.g.
Page execution time 0.7 seconds (sql text search query of 0,001 seconds)
Page execution time 0,9 seconds (sql text search query of 0,2 seconds)

above i said page execution time not including download / browser load time, which should not be effected


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
9 years 4 months ago - 9 years 4 months ago #55463 by wintercat
Thanks for the benchmark sample.

- does your website include asian languages without spaces or you want to overcome the limit for small words ?

Not sure what "without spaces" means but our website's language is Japanese.

- how much content (how many articles/items) does your website have ?

As of now it only has about 50 articles as our website isn't published yet. But It is a user-submission based website so the number will easily exceed 10,000(or not, but we don't want to end up switching to another cck when that happens)

I have set the "Use search %word%" on because partial word matching didn't seem to work without the option.
Testing the problem further, I found that partial matching works just fine without the option when "searching" using advanced search module.
But when "filtering" in category item list view, partial matching doesn't work without the option.
(When the option is turned on, it will work when "filtering". Same search word)
Last edit: 9 years 4 months ago by wintercat. Reason: typo

Please Log in or Create an account to join the conversation.

More
9 years 4 months ago #55465 by ggppdk
Hello

you cannot turn on this option will 10,000, performance will be unacceptable

but without it you can have a website with 100,000 items,

are you using FC v3 BETA 7g ?
search module(=>view) and category text search use the same text search method


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

More
9 years 4 months ago - 9 years 4 months ago #55466 by wintercat
Yes, I'm using FC v3 BETA 7g.

Ok...there are at least 3 search fields in Flexicontent which are
1. Search field in Flexicontent's Search(Or Advanced Search) module
2. Search field in search result page(shown after searching using the search module)
3. Search field in category/item list view(Above alpha index)

They all behave DIFFERENTLY.

When doing partial word matching with "Use search %word%" option on.
1.works
2.doesn't work
3.works

When doing partial word matching with "Use search %word%" option off
1.works
2.doesn't work
3.doesn't work

All using same condition, same search word("フリード", and the item I'm looking for is "フリードリヒ").
The reason.(2) doesn't work is because it puts "&searchphrase=any" to the result URL.
When removing "&searchphrase=..." it works whether the option is on or off.
Last edit: 9 years 4 months ago by wintercat.

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.301 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline