Inserting large amounts of data into a custom table during plugin install

I have some suggestions for you:

  • 1, create MySQL insert queries on your own.
  • 2, combine multiple insert values queries into one like
    values(1,2,3),(4,5,6)
  • 3, use $wpdb->query then

you need to figure out what the appropriate number of “multiple” is.

I’ve tried with 100 and it worked for me but I think the number varies on server settings.

Related Posts:

  1. How to delete all records from or empty a custom database table?
  2. dbDelta only creates the last table
  3. Is their any way to Extend WPDB class and Overwrite the Default Query Function
  4. Stackoverflow type of badge plugin giving warnings in WordPress 3.5
  5. Missing argument 2 for wpdb::prepare() Issue
  6. ob_end_flush error when using wpdb in plugin
  7. $wpdb->get_results() does not fetch results with unicode ‘WHERE’ clause
  8. post_content getting cut off on blank space on $wpdb->update
  9. Why am i getting this error? WordPress database error: [Query was empty]
  10. plugin ajax to external php file always return null
  11. When to call add_filter
  12. Doubt using $wpbd->get_col for a single column
  13. Access WordPress database outside of WordPress
  14. Correct way to perform non-cacheable DB query
  15. Help With MySQL to WPDB Query Conversion
  16. Creating mySQL procedure with $wpdb
  17. Problem with creating tables for Plugin
  18. Change commission_status paid when withdraw_status vendor is completed
  19. $wpdb->get_row returns column name instead of column value
  20. Create a table with wordpress plugin boilerplate
  21. plugin code is pulling information from database in one instance and not in other. What is wrong?
  22. Object method calling for global $wpdb in header.php
  23. Using wpdb without loading all plug-ins via wp-load.php
  24. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  25. How to insert multiple postmeta values with one query?
  26. Cannot get wpdb data (Error in a simple fuction) [closed]
  27. WPDB: Update table
  28. Issue running db create table query from static method
  29. $wpdb update query in plugin only updating one column
  30. Mowing site to another domain in simplest way
  31. Store plugin page content in wp_options?
  32. Displaying data from another database
  33. Using $wpdb in a plugin, what sort of data does it return?
  34. How to access the WordPress DB from a plugin file
  35. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  36. Linked pages from plugin on front can’t see $wpdb
  37. Need help creating asynchronous data scraper in WordPress
  38. ob_end_flush(): failed to send buffer of zlib output compression (0) in external php
  39. How to fetch WordPress database values in JavaScript widget
  40. $wpdb->delete not working for me
  41. any word search WordPress
  42. How to securely controlling data without keeping it in postmeta?
  43. Using id to show item
  44. No result after wpdb->insert
  45. How to fix slow comment query?
  46. Write mysql credentials in plugin
  47. Action hook “wp_insert_post” works but not for last imported post
  48. Proper way to trigger a MySQL query via link in a plugin
  49. get_var result empty for query of custom table in plugin admin
  50. Making plugin to use different table prefix cause permission problem
  51. Is it safe to increase/alter the size of the wp_post.guid column from VARCHAR(255) to VARCHAR(2048)?
  52. Get all the related data from WordPress DB
  53. $wpdb selects wrong database
  54. How to dispaly post informations (such as titles) in an admin plugin menu page?
  55. FATAL ERROR: WP complains about redeclaration [closed]
  56. How to check record is exist or not in WordPress CRUD Operation with $wpdb
  57. Create tabs inside Plugins Admin Page [closed]
  58. Allowing Two Developers Access to a Plugin on the WordPress.org Plugin Repository?
  59. WordPress wp-json API – Custom Post Type returns 403
  60. Add .html extension to custom post type taxonomies
  61. Translate wordpress plugin [closed]
  62. Styles and Scripts, Selectively enqueue across entire site
  63. Nested shortcodes
  64. Exclude custom post_type in sitemap generation?
  65. Removing WordPress Plugin Menu Item for a specific user
  66. How can I use RDFa with WordPress?
  67. How to add an attribute to the body tag with a plugin?
  68. What function can I use consistently to escape possible HTML for editing and display?
  69. How can I make uploaded images in the editor load with HTTPS?
  70. Ultimate Member: Redirecting after registration
  71. how to create site exit messages with destination url displayed
  72. Magazine subscription sales through WP?
  73. Changing “elapsed time” to “time remaining” on MP3-jPlayer audio player with CSS or PHP changes
  74. Ctrl+V images from clipboard into wordpress editor
  75. Custom post types – remove default post supports through empty array?
  76. Release the plugin in the WordPress repository where redux is used
  77. Ajax object not defined – JS file is in plugin folder
  78. Is there a good way to load tiny_mce_popup.js through editor.windowManager.open?
  79. I/O Usage goes max. just after every new post published and WP site down
  80. Personality quiz in wordpress using a plugin
  81. Adding custom post category to categories widget
  82. How to ignore fields if empty?
  83. Error messages in Multilingual part of the site
  84. WordPress how do I change images used in plugins?
  85. Add WooCommerce vendor slug to auto-generated SKU
  86. Admin Custom Login loses settings on Code and Data migration
  87. custom REST endpoint not passing body of POST request to callback
  88. How to hook into search results template or query?
  89. How can I insert a record into a custom table from my custom form in my custom admin page?
  90. how to create table during plugin installation in side a class
  91. Why function hooked using object are executing at all time?
  92. Create a blank admin page from plugin
  93. Private WordPress blog, requires user registration approval, and allowing users to login with OpenID
  94. Which part of the plugin to change so the updater won’t register the next version?
  95. Publish post facebook page & twitter automatically [closed]
  96. How can I save the selected page in the dropdown after anyone clicks on Save Changes?
  97. How can I display an attribute from each post inside foreach($latest_posts1 as $post )
  98. Wrong block appender button showing
  99. Check Plugins in Use by Mutli Site Network
  100. Plugin to transfer new/updated files from media library in “/wp-content/uploads/” between prod environment and preprod environment?