I’m getting a 504 Error when I’m trying to access Tab 2.2 in the WPSolr admin area of my WordPress website.
This is the Define Your Search > Data screen.
I have hundreds of thousands of products with lots of metadata. Could this be why this issue is occurring?
Probably.
This page is gathering all custom fields with a group by from the wp_postmeta.
If this table is huge, the SQL query can overwhelm the SQL server resources.
Do you have any suggestions for how I might go about accessing the page? In theory, what would allow me to access it? More server resources? Do you think it’s timing out in AWS, or something with my server environment? Anything I could do to manually write the options into the database?