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.
Thread Starter
Li-An
(@li-an)
Thanks for these explanations. I will make a test on my principal blog (1700 posts) and will compare with Relevanssi results.
G
(@gnetworkau)
@li-an how did it go, does it work ok?
Thread Starter
Li-An
(@li-an)
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.
Thread Starter
Li-An
(@li-an)
Oops, sorry, I mismatched with GSearch Plus plugin. I will make a test with your plugin.
Thread Starter
Li-An
(@li-an)
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: http://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 🙂
Thread Starter
Li-An
(@li-an)
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.
