'Wordpress website not showing all results

The website has a lot of posts , about 90,000. But recently noticed that searching for a post that i added recently and even older posts are not appearing in search results. Ive cleared cache etc, disabled cloudflare,,disabled plugins Nothing seems to fix it

Anyone ever run into this problem?

Could this be because of such a large database ? What would be filtering them posts out of search results because Im able to view them posts no problem inside the admin area, just no sign of them on search results



Solution 1:[1]

If I were you by having this only information, I would first enable my WordPress debug mode ( https://hostadvice.com/how-to/how-to-debug-and-log-errors-in-wordpress-site/ ) and check if my WordPress records any errors inside the wp-admin/error_log file or throw any warnings/errors at the posts page while attempting to search.

If nothing is there, I would reach my host to double-check the MySQL service for me and MySQL logs to ensure there are no issues with my database.

Last but not least, you can also install a plugin like https://wordpress.org/plugins/query-monitor/ which can help monitoring/reviewing the database query that is executed when you perform a post search and see if it returns the correct data.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 BrunoMirchevski