Scalability
We are experiencing some scalability issues with over 100k posts, and ~30M post_metas.
Do you have plans to analyze and optimize the plugin?
Hello,
I expect that you experiencing some issues when working with sorting and filtering on the overview pages?
We are aware of performance issues on large datasets, but most of our code is using the WordPress query and meta query functions, that is not really optimized for large datasets.
So at this moment, there might be some possible minor improvements, but to make it really run smoothly on large datasets, we need to build some kind of indexing strategy. But there are no plans to start the development of something that big right now.
The issues (mainly timeouts) we are facing happen:
– on the Admin Columns setting page, when all post_meta for a certain post_type are being fetched
– on the post_type listing page
Checking the database queries on each of the pages, I find it strange that a large number of post ID’s are being used on an ‘IN’ statement for filtering a field.