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. wp db request without refreshing the page
  58. Make change in media library affect images in published articles
  59. How to add Wrapper Div/container element around WordPress Widget Content
  60. UpdraftPlus installed malware – scared to download or update plugins now! [closed]
  61. Duplicate New User Registration notices (BuddyPress and bbPress both installed)
  62. Is there any plugin which enables users to rate comments in thumbs up-down way?
  63. Plugin Repostitory Questions
  64. Get site url and updates data, then use them
  65. Error When Trying To Login [closed]
  66. How do I convert my WordPress website to be domain agnostic?
  67. Get Image Having the ID [closed]
  68. How to create plugin auto create page wordpress?
  69. why I cannot activate elementor plug in?
  70. How to find the following specific WordPress variables?
  71. Load extra post content from plugin, after load basic post content
  72. Trying to get property ‘ID’ of non-object in /wp-includes/class-wp-query.php on line 4044
  73. WordPress asks to update a plugin already updated
  74. Why do I need to reload the page for WordPress to see the new custom field added with jQuery
  75. How to store a secret for a plugin inside public_html
  76. WordPress:Custom banner from psd trying to cut out a button area so the website link can be clicable not working
  77. Global $wp_admin_bar always returns null
  78. Shortcode generated widget to appear on same line as heading text and button
  79. Show custom taxonomy in theme
  80. How to prevent encoding plugin HTML output to entities?
  81. How to differently style pages that display posts of different category in WordPress?
  82. WordPress FTP/media directory permissions problem?
  83. Social sharing plugin directing to blank page after post sharing
  84. accessibility of an object created in a plugin, from the header
  85. Simple fields plugin WordPress show repeatable file field
  86. How to check my WordPress.org site MySQL queries generating items?
  87. how to make a plugin secure, so any one if changes something in plugin, it just disables it self and notify us on server? [closed]
  88. WooCommerce – Adding notice above products on Shop Home [closed]
  89. Plugin update warning
  90. JQuery UI plugin not working in IE7?
  91. Possible to change meta data single quotes to dobule quotes in yoast wordpress seo? [closed]
  92. how to know that a wordpress plugin support using API?
  93. Activate plugin button do nothing [closed]
  94. Am having issues intergrating this api into my wordpress site, any help please?
  95. wp_enqueue_script doesn’t load JS in plugin
  96. AI Code For OpenAI
  97. How to Deobfuscate a sourcecop protected WordPress plugin?
  98. How to get selected variation from URL?
  99. onSplit not create my custom block
  100. Widget saving but showing “waiting” animation [closed]