Speeding Up Bulk Post Creation – wp_insert_post & update_post_meta

Siteground has WP-CLI installed and when you have WooCommerce installed it adds its own set of WP-CLI commands.
See this:
https://github.com/woocommerce/woocommerce/wiki/WC-CLI-Overview

With this your solution would be cleaner as it would go though WC’s API.

Maybe you can also check for ideas how WC does it. I remember in the add/edit product UI there was a link to (re)generate variations but there was limit I think.

Related Posts:

  1. Steps to optimize WordPress in regard to server load and website speed?
  2. Website is slow: advice on optimization
  3. Can we have a post without a slug?
  4. How to properly insert a stylesheet in wp_head
  5. Using Multiple Queries of “home_url” vs. Calling a Variable Multiple Times
  6. Could a higher number of registered image sizes affect performance?
  7. Page taking time in loading. Also used lazy loading but doesn’t work?
  8. Optimizing site speed by localizing paths
  9. get_the_id, get_the_permalink, and get_the_title all with one DB call
  10. High traffic management in WP
  11. wp_set_post_terms() seems very slow
  12. admin.php taking 14 seconds
  13. How to optimize recaptcha__en.js
  14. How can I optimize my website for improved speed? [closed]
  15. What’s the best way to search for a UPC code in a Database?
  16. what does O(N) mean [duplicate]
  17. Which Python memory profiler is recommended? [closed]
  18. What is the difference between spark.sql.shuffle.partitions and spark.default.parallelism?
  19. Big O, how do you calculate/approximate it?
  20. What is the difference between set and hashset in C++ STL?
  21. Java check if boolean is null
  22. the asymptotic growth of n choose floor(n/2)
  23. Slow Query for the wp_options table
  24. What is the best caching option for WordPress multi-site on non-shared hosting?
  25. Why is home (a lot) slower than other pages?
  26. How many posts can I have in a WordPress website?
  27. WordPress so slow to load on MAMP
  28. Do multiple revisions really slow down WordPress?
  29. Fastest server stack configuration for WordPress?
  30. Cache WordPress translations
  31. What is the proper use of https in a modern E-Commerce environment?
  32. What are best practices for configuring a server for WordPress sites?
  33. Utilize WordPress Authentication Only
  34. WordPress tries to load “next page” after done loading current page
  35. Is checking whether the blog is installed necessary?
  36. What is a reasonable get_num_queries() result?
  37. Performance impact of using functions in WordPress?
  38. Hardcoding and WordPress Performance
  39. What should be disabled to run on an internal network with no access to the Internet?
  40. Does running WordPress on Nginx do “squat” for its performance?
  41. The effect of spam comments on hosting resource usage (CPU)
  42. What other plugins are there available to track app performance for wordpress?
  43. Combining multiple javascript and css files
  44. How many caching plugins should be used?
  45. Why can’t /wp-login.php be load balanced?
  46. Preload external PHP information
  47. Removing translation textdomain
  48. AWS (or others) vs VPS
  49. Do I manually minify css code in my main theme or child theme?
  50. Downsize CPU & DB usage in wordpress
  51. WordPress 3+ slow load times on Ubuntu 10.10
  52. WP Optimization: Removing Orphaned wp_options (especially the autoload ones)
  53. Point static content like css and js to cookieless subdomain
  54. upper limit on concurrent editing?
  55. Will Gutenberg Have a Negative Impact on Page Speed?
  56. Preload Cache for thousands of posts may be on non-production environment
  57. Page Loading Issue [closed]
  58. fastest replacement DB
  59. Suggestion to improve slow WordPress page
  60. Optimise page loading time faster on Genesis child theme [closed]
  61. Optimizing a WordPress site
  62. Long wait times in first part of call to WordPress on Azure
  63. does wordpress serve static files?
  64. Server Hardware for WordPress [closed]
  65. Conditionally include files in functions.php?
  66. WordPress network vs Separate installs
  67. Bandwidth usage increased in WordPress 3.5
  68. How to test site speed?
  69. Remove unused CSS and JS
  70. Measure WordPress performance on different hosts
  71. Calling various CSS sheets in header a good idea?
  72. Optimizing function that automatically creates internal links based on post title string
  73. Using functions repeatedly instead of variables
  74. WordPress Site Speed (Maybe Server Issue)
  75. Does fixing PHP notices improves website performance?
  76. How do I make content only load on desktop? [duplicate]
  77. Slow issues with Website running WordPress on Azure
  78. WordPress digitalocean taking forever to load
  79. Favicon is loading very late
  80. Website slow : my fault or the host?
  81. Website Load Time takes forever
  82. What can be a solution when my wordpress is extremely slow?
  83. get_template_part calls amount and performance?
  84. Improve WordPress performance on large number of posts
  85. licenses, subscriptions, etc and the impact on performance
  86. Website is loading twice unnecessarily
  87. WordPress slow even use blank template
  88. What’s the best way to dequeue / remove uncooperative scripts and styles?
  89. Is WP-Cron / wp_schedule_event suitable for time-consuming actions?
  90. Using static home page and wordpress only as a blog
  91. Optimising amount of calls to custom fields
  92. High I/O load when hosting lots of wordpress sites
  93. How we can reduce wordpress page loading time? [closed]
  94. How to Aggregate, minify and compress (AMC) static and dynamic resources?
  95. Site too Slow to establish db connection?
  96. How to resolve google page speed issues for wordpress website
  97. To what degree can use of caching-plugins and a CDN boost WordPress performance? [closed]
  98. TTFB is too slow in back-end [closed]
  99. What kind of data that 3rd part dependencies using?
  100. FreeBSD performance tuning: Sysctl parameter, loader.conf, kernel

Leave a Comment