Again, could you please stop posting coding suggestions from AI sources (Grok, CloudFlare AI, etc)... AI sources don't have access to the entirety of the code base to make worthwhile suggestions, we have the same tools to run directly on the stock builds without any 3rd party additions to HTML or PHP coding (either added by a user, developer, or 3rd party tools such as CloudFlare which inject HTML into pages); we regularly run the product through our own IDE tools.
UBB.threads has had had FULLINDEX searches for eons, enable it in your Control Panel (see the attachment) if it is a feature that you would like to use.
I obviously was unaware of this. Don't you think it should be the default setting?
The reason it's a slow query during a search is because it's trolling through your hundreds of thousands of posts looking for the search query, it only has impact to the user performing the search.
A search will query all "post_default" cells relating to a Post or Topic (and not the "every single row in the db" as your post claims) as they contain the contents of a post.
Then why does the query log say Rows_examined: 1051691?
