How to properly send many mysql queries via php and what happens with ajax requests after they are sent?

There is typically a hosting limit to how long PHP can run, on shared this can be as low as 60-90 seconds. Since WP’s Ajax is just another instance of PHP load it will likely be subject to that restriction.

Even if it’s disabled any error risks knocking such a long running process out.

Unfortunately there isn’t really any mechanism in WP for running long tasks. You might want to look for other PHP solutions for it.

The closest WP option would be to use WP cron to toggle task periodically, which will grab smaller share, process it, and track progress.

Related Posts:

  1. Undefined function mysql_connect()
  2. MySQL “Or” Condition
  3. Transaction when using WP functions rather than vanilla SQL?
  4. Can i use php sql functions instead of $wpdb?
  5. How to validate WordPress generated password in DB using PHP?
  6. Custom query to get post names beginning with a digit
  7. How To Make Connection To WordPress Data Base In A Plugin?
  8. Jquery ajax to custom php file: returning blank data
  9. Add value to usermeta without removing previous values?
  10. How can I call a row of user specific data from a custom table added to the WP Database
  11. How to merge local and live databases?
  12. How to track a users progress through pages by inserting data into WordPress Database?
  13. the_author_meta not working
  14. Successful or Error Message after running mysql code in functions.php
  15. Performance issues with large website [closed]
  16. Create a quick start wordpress installation [closed]
  17. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  18. theme options echoing multiple times
  19. WordPress 3 – how are passwords stored and how do I compare to them?
  20. mysqli_real_connect() – authentication method unknown to the client Warnings
  21. How to create another version of my site based on the same database
  22. how to echo all tables that start with a prefix
  23. Do I need to prepare query before get_results(), get_row() and get_var()?
  24. How to create and work with custom data / tables (i.e., for arbitrary data)?
  25. How to select WooCommerce products by post_meta and order them
  26. Stumped on migration
  27. PHP code inside shortcodes
  28. Show MySQL errors that occur when I excute $wpdb->insert()
  29. Remove one value in dismissed_wp_pointers?
  30. WordPress Site Running Extremely Slow on Dedicated Server
  31. Accessing data from a non-WP database/table within a page content
  32. I want to select the from values from database in WordPress? [closed]
  33. WordPress not reflecting changed of the database
  34. User management system similar to wordpress one?
  35. SQL Injection blocked by firewall
  36. WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
  37. How can I save unique user data on my site? [closed]
  38. Ordering users by custom user meta
  39. Long running queries
  40. Refresh table data with Ajax
  41. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  42. Using custom tables for old posts
  43. Help with a $wpdb MySQL Query
  44. How i can obtain all the post meta for a specific post as an array?
  45. Multiple meta_key in one global $wpdb;
  46. Custom array from a query only write the last row of the query
  47. WordPress member notification
  48. Moving wordpress site from localhost to live server using GoDaddy cPanel
  49. How does WP work in conjunction with a web server?
  50. WordPress Block developer from exporting Database via PHP
  51. $wpdb returns duplicate posts
  52. Location of core code for database connection and get_header
  53. How do I display offsite database info on my wordpress site?
  54. Creating Database Table vs. Adding MetaData to Post & User
  55. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  56. Most commented posts by time period (last 12h, last 24h and etc)
  57. Use $wpdb or other PHP script method to find/replace in WP database
  58. Issue with fetching mysql data and displaying results via shortcode in webpage
  59. Hide posts if user is added to it WP_query
  60. Custom route and query
  61. How to unserialize data from MySQL
  62. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  63. WordPress WP_Query without query GET parameters
  64. Known Issues in WordPress When Upgrading PHP to ver 7
  65. Edit Account – read and write to MySQL
  66. Get the id of the row from database on click of a button [closed]
  67. WPDB secure custom form
  68. Why when I create a new post I found 2 record related to this post into the posts database table?
  69. mySQL queries are executed twice on wordpress website
  70. Query the links Database
  71. Most viewed posts in WordPress
  72. SQL error with custom query
  73. Modify WooCommerce used to get all orders in dashboard
  74. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  75. Get mysql data for Quick Edit panel
  76. Weird fonts showing which are coming from database
  77. Inside Array – “unidentified index” error with “prepare was called incorrectly” despite not calling the prepared statement with wordpress [closed]
  78. WordPress Bad Request Error 400
  79. I am facing this error Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  80. What is the correct way to search 3 custom fields only in WordPress?
  81. cant insert data in a custom table in phpmyadmin
  82. How to import woocommerce custom fields data into another site?
  83. Change upload URL by mime type
  84. autocomplete in wordpress using ajax with json-data
  85. Unexpected behavior when trying to manually install WordPress on macOS Sierra
  86. WordPress post insertion from PHP file
  87. New database entry to trigger runing PHP/SQL query through link with token, without logging into the website
  88. Query doesn’t display text data with apostrophes
  89. I want show only data for today
  90. Rewrite SQL query as a prepared statement and use in foreach loop
  91. SQL Query Search page
  92. Include a custom field in mysql query
  93. MySQL queries in WordPress
  94. Let users register weight each day and save it in DB
  95. How to pass username into form that sends data to database
  96. Submit cf7 form to cfdb as pdf/BLOB [closed]
  97. Your PHP installation appears to be missing the MySQL … After deleting and restarting from cpanel
  98. Execute multiple PHP Snippets causes error?
  99. what to do after instlling cyberpanel on VPS
  100. Can’t insert into a database wordpress