Hi @stark

Could you test posts 22515 and 11804 on the first tab of the Sandbox? I am curious which data were indexed in those posts, may be the SAME data was indexed for all those posts. The same relevance ratio (80%) is very less probably for such amount of posts.

Also I would see the code you are used to put meta fields to the index. Could you share?

Thanks!

Hi @marcellosalass

Actually WPFTS could be not that great for you in case you have millions of records (e.g. posts).
The whole Wordpress could be not good for you either, because to handle such amount of data you will need to use specific optimization and caching algorithms and even clustering.

I would like to propose you to use full-text solutions based on Apache Solr or Elastic Search - those tools are implemented in Java and work way faster than PHP+MySQL solution provided by WPFTS and they are especially good for big data.

Alternatively you can wait until we release a new WPFTS version (in 1-2 months) that can use self-hosted Elastic Search engine to keep full-text index and uses WPFTS data collecting algorithms.

Thank you for the question.