We are preparing a CSV for importing in WordPress using Toolset.
We will use WP all import plugin.
It includes a large set of properties (~ 1M).
We are wondering if the performance of WordPress will be affected after importing the data?
We have created multiple custom fields (custom post type = 'properties').
Could the import damage WordPress performance?
Should we consider any things to avoid degradation of the website?
We are wondering if the performance of WordPress will be affected after importing the data?
I think yes, anytime you are working with a large database it will have some impact on the overall performance of the site. Queries will take longer because there is more data to consider. I've never personallly worked with a database containing a million posts, so I don't have a good frame of reference, so you might need to try it and see. You could try setting up a staging environment to perform the import before you import into the live site, for testing purposes.
We have created multiple custom fields (custom post type = 'properties').
Could the import damage WordPress performance?
Again, queries will take longer and will require more server resources. So yes, a large database size will make a noticeable impact on overall site performance. If you have custom search Views, those queries will take longer to perform and may require a large amount of server resources. More complex queries like distance-based searches will be impacted by a large database set, but that's just the nature of working with a considerable amount of data.
Should we consider any things to avoid degradation of the website?
You should consider optimizing your search queries for performance. Custom field queries, for example, are less performant than taxonomy queries (https://metabox.io/custom-fields-vs-custom-taxonomies/#:~:text=Because%20of%20the%20WordPress%20database,key%20and%20value%20is%20slow). You should consider using caching systems to help improve performance, CDNs for asset delivery, and robust server-side infrastructure. You might consider contacting your host company for more server-related optimization. I would also research WordPress optimization in general for large data sets, like limiting post revisions, managing expired transients, limiting comments, limiting pingbacks, etc.
