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

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?

that depend number of item and number of field and your server performance
try it

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

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)

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

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.