WordPress plugin: efficient way to store large data

There’re few plugins to storage it on WordPress database. I recommend you save as users.

I believe one of these plugins will help you:

https://wordpress.org/plugins/wp-all-import/

https://wordpress.org/plugins/wp-ultimate-csv-importer/

To send emails, you might use an Email Marketing provider, like Mailchimp. In this case you can import all the users to your mailchimp account with this plugin:
https://wordpress.org/plugins/mailchimp-sync/

PS: You can search some more useful plugins for MailChimp or something else up here: https://wordpress.org/plugins

Related Posts:

  1. How does WordPress handle MySQL row lock errors?
  2. Help With MySQL to WPDB Query Conversion
  3. WordPress Backend HA (Automatic failover)
  4. DB Query not working in Plugin
  5. Integrating Custom Database with WordPress
  6. How to display results from a data table with an encrypted user id?
  7. How can I delete the options from DB when the plugin is deleted?
  8. How to Add an Index to Plugin Database table
  9. Creating two database tables via plugin
  10. How to properly insert data into custom table via plugin
  11. Can I explicitly specify ENGINE=InnoDB in WordPress?
  12. Bad Request (Invalid Hostname) on working server, database problem
  13. $wpdb->get_results() does not fetch results with unicode ‘WHERE’ clause
  14. Changing BIGINT to INT
  15. WordPress register_activation_hook table creation not working
  16. greatest() function returns undefined property
  17. How to write one comment and publish on every post using database or plugin?
  18. Default Plugin Settings Not Writing to Database
  19. How to determine what is generating large amount of database queries?
  20. Building an email signup form. Where should the information be saved in the DB?
  21. Plugin Options Not Saving to Database in WP 4.5
  22. How to create custom tables in WordPress using my own plugin?
  23. Is it possible to create Custom Post plug-in?
  24. Creating mySQL procedure with $wpdb
  25. Prevent duplicate records in plugin table
  26. How can I perform high-level database merging for WordPress within continues delivery?
  27. 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
  28. WordPress plugin creation how to execute .sql in order to insert multiple rows at activation of plugin
  29. Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
  30. Insert data from .sql file in wordpress plugin
  31. Automatic switch to backup database on fail
  32. How can I change the meta_key for a particular piece of information?
  33. Migrating to WordPress Recipe Plugin and Some SQL Issues
  34. Multiple instance of data in plugin custom database table on plugin activation
  35. Better ads plugin has 500.000 entries in wp_postmeta
  36. Can I create a table on my DB without creating a plugin?
  37. WordPress : Explain Plugins & Theme string value in database
  38. Is it necessary to auto delete my WP plugin database tables when users deactivate/delete my plugin?
  39. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  40. How to insert and call new data in wordpress website database through a plugin
  41. WPDB: Update table
  42. Issue running db create table query from static method
  43. Separate database for a wordpress plugin
  44. dbDelta not adding additional columns in plugin database update
  45. Best/Correct way to add an option to a category
  46. Always get creating a new table with foreign key
  47. How to do database for download stats?
  48. What is the WordPress approach to custom data?
  49. How to create plugin/ page that reads from database
  50. External wpdb connections in different plugins on single page
  51. Comment “like” problem – “users who like this” avatar linking to current user profile instead of “liker’s” profile
  52. Way to send multiple values for column to MySQL?
  53. Plugin generating unexpected output – on WP mysql dump import
  54. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  55. Can’t create tables with my plugin
  56. add_action for publish_post doesn’t work
  57. How to make a Product page without ordering and database
  58. How to get the custom field value using SQL query
  59. Need to know if my approach to designing a geneaology plug-in for wordpress makes sense
  60. What database state changes happen after a post is manually “updated” with no changes?
  61. I created a plugin with ‘view page’ that uses MYSQL + PHP. When I use wp_insert_post(), it turns everything to HTML
  62. Cant create table on plugin activation
  63. Performing CRUD operations on front end in wordpress
  64. I want to schedule email (date, time is in database->table) wp_schedule_event() not working
  65. How to securely controlling data without keeping it in postmeta?
  66. $wpdb->insert not working inside save_post tag
  67. WordPress UPDATE queries on MySQL database stuck
  68. Store GravityForm data in phpmyadmin (mysql)
  69. Moving a few select DB tables to a new WP instance
  70. WordPress database problem wp_posts, primary key
  71. Where do the section input fields values are stored in database
  72. HyperDB failover Delay
  73. My plugin can’t see my files
  74. Resetting AUTO_INCREMENT primary key
  75. how can i get records from wp_postmeta table using particular meta_key in database?
  76. Re-writing MySQl query for execute faster
  77. Create Database Tables on Plugin Activation hook
  78. Write mysql credentials in plugin
  79. Linking Plugin Files to WP
  80. Create New Admin Menu Section – Like how custom post type works, in a way
  81. Creating fields in the database
  82. How to submit the custom form data in database in WordPress without plugin?
  83. how to search through plugin in wordpress cimy-user-extra-fields?
  84. Get all the related data from WordPress DB
  85. How to display blog posts only authored by the administrator
  86. get_option returning a different value from what’s saved
  87. register_activation_hook not working
  88. On the same site, how do I send data from a plugin file to a theme file?
  89. plugin doesn’t retrieve data from database
  90. How would you require and automatically download dependent plugins?
  91. Publish Post After Click On A Link
  92. Replace existing pages with new pages, keep menu links
  93. gallery option is not available in media upload box in costum theme option page
  94. Object Oriented Plugin not working
  95. WordPress Jquery UI Spinner
  96. Shortcode do not return the right data in post
  97. Avoid WordPress header bar when form submission using admin_post in the frontend
  98. Change localization only for plugin
  99. How to get author developer link on plugin page
  100. Is there a plugin that will override the “Error establishing a database connection” message? [closed]