get Threads through SQL or ElasticSearch

[FloV]

Hey everybody,

i've a couple of custom AddOns in my forum. Right now they are firing a lot of queries to get latest and similar threads. My question is: Would it make sense to replace those sql queries with ElasticSearch queries? I could save 5 sql queries per page but i don't know if the elasticsearch would result in a faster pageload.

Thanks for your help

Flo

PS: Of course ES is installed already!

 

[Aayush]

I am guessing with the similar thread functionality you are actually doing full text searches.
If those queries are doing full text search then I would suggest you to go for it. I've run Full text search on MySQL which took an entire minute and the same query when switched to ES took about 20 ms. The gains are remarkable for full text searches.