I have created a site that relies heavily on the ACF plugin. http://thecrossingchurch.com/. The site utilizes the ACF plugin to create a theme switcher on the site that allows you to dramtically change the look and feel throughout the site. Basically you choose what type of theme you want to display and then it displays a variety of ACF fields that are different for each theme. This has caused the wp_postmeta table to have over 400,000 rows in it. I’m hearing from GoDaddy that because the table is so large Apache is crashing and causing my site to go down. Any thoughts on this or how I can fix the issue?
Sorry to hear about the issue, but no, I don’t have any thoughts on a fix.
the wp_postmeta table is not built for mass data, but perhaps considering upgrading your server may help?
Also, using a caching plugin to page cache would prevent the need to search the DB on each page load.. But I’m not sure how this would cope with the dynamic theme switching…
Sorry I can’t be of much help on this one.
Thanks elliot for the quick reply. I installed wp_supercache plugin so hopefully that will make a difference. I don’t know if the server can really be upgraded anymore, we already have a dedicated server through GoDaddy. They haven’t been very helpful to narrow down on why the issue is occurring, except to say wp_postmeta is too large.
So do most people not use the ACF plugin to build projects that are this complex? Are other people having similar issues?
Should I look at rebuilding in some other way? ACF works great, but the site can’t keep crashing.
Something of this scale needs either caching or a more powerful scaleable server. Go Daddy is quite a cheap option and their servers are not very powerful. I hope this doesn’t offend you.
I would consider looking at WP engine, site5, or perhaps even amazon?
The topic ‘wp_postmeta table too large’ is closed to new replies.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
The ACF site is currently experiencing some issues.— Advanced Custom Fields (@wp_acf) September 21, 2022
We apologize for the inconvenience and we are working hard to get it back up and running as soon as possible.
© 2022 Advanced Custom Fields.