How does it work ?

I don’t use an index, just some clever use of the “locate” SQL function in my own algorithm.

That way the database does the gruntwork of the sort – something its designed to do.

I let WordPress’s own search handle the WHERE part of the query, and inject an extra field, and then order by that field.

The algorithm was originally written for a commercial site I work on (not WP) and handles 20k page loads a day and searches through nearly 15k items. I figured if an SQL based solution could work for that – there’s no reason it couldn’t work on wordpress too.

Thanks for these explanations. I will make a test on my principal blog (1700 posts) and will compare with Relevanssi results.

@li-an how did it go, does it work ok?

I will make a post on my WP plugins blog. The plugin works nice but the results are not as good as with Relevanssi.

Thanks Li-An.

Good to hear it works nice!

This was never meant to replace Relevanssi’s fine control of results, it was made for 2 reasons.

1) Simplicity – little/no config/setup – and ta-da relevant results.

2) Memory use. By off loading the sorting to MySQL there are no index’s to maintain and no out-of memory errors for large indexes when using a host that’s not-so generous with php-memory limit.

Oops, sorry, I mismatched with GSearch Plus plugin. I will make a test with your plugin.

Test made ?? Very good results, better than GSearch Plus.
It lacks: searched term color and excerpt focused on searched term. I will make a review on my WP Plugins blog: https://wwww.echodesplugins.li-an.fr/

Hey Li-An…

I just pushed out V 2.0 with both of the features you just mentioned: highlights, and focus on search terms.

Let me know what you think and if its worth 5 starts now ??

Well played ?? I will put a 5 stars.
But maybe it could be cool to style the highlight (background color…) as strong is not very obvious.
I will look if there is a great difference in time in the showing of the results between the two different plugins.