Hi,
We have a requirement for wildcard search('%people%') on a table column. We have gone through Hibernate Search documentation, it says suffix wildcard query will cause performance issues. We have gone through blogs, found that we have to user ReverseStringFilter but did find any example using with it and it will solve half the problem of suffix query('%people').
But we are looking at a solution which will solve complete problem i.e searching for '%people%'.

Thanks in advance.

Hi,
what we mean with that warning in the documentation is that a query like that will be quite slower than other full-text queries.
So avoid creating such a feature if it's not important in your use case, but if you are required to implement it you can still do it (don't let the warning scare you).

It might be fast enough - what we mean with the warning is that you might want to verify how it performs. With some luck it will be great, just don't take it for granted: depending on many factors, this might be slow.