Admin Column Performance for High-Volume and Live Data Search
Has anyone here tackled a larger-scale data updates, beyond building a fully custom grid with progressive loading in React? I’m curious if there are any plans in Admin Columns Pro for better handling of larger datasets.
I’m working with something like the dataset below, and it’s growing daily. ACP works well out of the box for smaller sets, but once you hit scale, it becomes tough to manage in the admin without building your own high-performance tools. The thing is, ACP has a great UI and workflow, until you get into larger data sets. At that point, it feels like you’re either all-in on a custom solution or constantly fighting limitations of some kind when you start to scale.
Would love to hear how others are managing this or if anything’s on the roadmap for scaling the app for larger data.
* ‘xsz_commentmeta’: ~4.2 million rows
* ‘xsz_comments’: ~8 million rows
* ‘xsz_options’: ~800 rows
* ‘xsz_postmeta’: ~5 million rows
* ‘xsz_posts’: ~900k rows
* ‘xsz_termmeta’: ~6.6k rows
* ‘xsz_usermeta’: ~4.2 million rows
* ‘xsz_users’: ~184k rows
* ‘xsz_wc_orders_meta’: ~494k rows
* ‘xsz_woocommerce_order_itemmeta’: ~100 million rows
Looking for best practices or tools to efficiently manage and display updates across datasets of this size. Any insights or approaches you’ve found effective would be greatly appreciated!
Here is a sample of what we built so far and would so much rather use ACP for this.
Thank you for your time and efforts and all the best ….
You must be logged in to reply to this topic.