PHP Memory Error When Updating Vendors

I have just over 140,000 Vendors and around 4000 listings on my site. I mostly use WP Sheet Editor to update both. I have been using Hivepress since December 2025 and my site is fully hosted with Wordpress.

Everything worked fine initially however when I came do do a large scale update on the vendors in July this year I found that the upload repeatedly failed. The error log always showed something along the lines of:

PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) in /wordpress/core/7.1/wp-includes/class-wpdb.php on line 2324

By reducing the number of records per batch right down and adding a larger delay between batches I was eventually able to update all the records.

I am now trying to update these vendors again but now get this PHP memory error even when trying to update just a single record.

Even taking WP Sheet Editor out of the equation, if I go to “Vendors” in the wordpress dashboard, select a vendor, change a single text attribute and click “Update”, it fails and the log shows this same PHP error.

Updating and adding listings still works absolutely fine and I can upload those 20 at a time without errors. It is just the Vendors where there is a problem.

With the help of ChatGPT I have been through a number of diagnostic steps and troubleshooting including disabling all plugins but no matter what I do I still get this error.

The summary GPT suggested I provide is:

PHP memory limit 512 MB; normal HivePress vendor edit uses ~59 MB (and ~21 MB in troubleshooting); saving even a simple text-field change exhausts the full 512 MB; reproduced with only HivePress active in Troubleshooting Mode; fatals repeatedly occur in /scripts/object-cache.memcached.php lines 730/919, although some attempts exhausted memory in WordPress core; Site Health confirms an object-cache.php external object-cache drop-in.

Please help.