That’s probably the problem there, it’s an extremely high amount to search for.
I would rather recommend using the Index Table engine for this purpose instead of the regular one: index table documentation
Even if you can make it work with the regular engine, the search query is going to be insanely big and it’s going to take forever to execute. (or might not be executed at all) It’s completely fine with a few custom fields, but for hundreds it’s not recommended.
The index table engine however takes care of this issue by pre-indexing the configured fields, so the final search queries are super fast and very efficient.
Best,Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)
