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 column count doesn’t match value count at row 1 [closed]
  3. dbDelta support for FOREIGN KEY
  4. is it possible to run some php code within a wordpress page?
  5. How to correctly submit a search form and display the result in an independent page
  6. Check if post of title already exists
  7. $wpdb->delete column values IN ARRAY()?
  8. Custom SQL query to get List of posts with featured image url
  9. Does WordPress cache get_user_meta() results?
  10. Delete post revisions on post publish
  11. Using Echo in ShortCode – Stuck
  12. Problems migrating WordPress to localhost
  13. error importing localhost export file to server
  14. How to sort results from a custom database table
  15. Update some database fields when post is saved
  16. sql query to put quotes around numbers in img tag
  17. No wp-config.php file on local install of wordpress – site still displays
  18. Use ajax to update_post_meta
  19. Is the outdated PHP mysql extension a requirement for WordPress 4.6?
  20. What SQL / WordPress queries would need a nonce?
  21. Different database query in function.php using mysqli
  22. Strange wordpress slowness
  23. Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
  24. Why is variable not working on custom sql query using wpdb?
  25. How can I export posts with featured images, without download them
  26. How to securely provide a $_POST var in WP_Query with PHP 7?
  27. Create WP_Query to search for posts by their categories or their parent/child categories
  28. WSoD being caused by this piece of code
  29. How to display data from custom table in wordpress phpmyadmin
  30. Update results, Before deleting the related category [closed]
  31. Sum the total amount of a specific product purchased per user and display in table
  32. get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
  33. Replacing mysql_escape_string in a custom plugin when moving to PHP7
  34. Weird 404 URL Problem – domain name being placed at end of urls
  35. database sent to a JSON file
  36. $wpdb->insert() does not Insert record in a table
  37. Help with a $wpdb MySQL Query
  38. WordPress SQL injection
  39. How i can obtain all the post meta for a specific post as an array?
  40. multiple where condition in result query
  41. Can’t Query Custom Table Using $wpdb Method
  42. $wpdb returns duplicate posts
  43. Update postmeta after theme switch
  44. Should I use WordPress to skin a database website?
  45. Creating Database Table vs. Adding MetaData to Post & User
  46. WordPress Custom SQL Table with UserID Filter for results
  47. How can I add a new row in a separate database when someone registers via WordPress?
  48. I can’t update my data through $wpdb
  49. Output: “Array”
  50. How to use mysql LIKE with wpdb?
  51. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  52. WordPress WP_Query without query GET parameters
  53. How to use AJAX in WordPress in MYSQL query?
  54. Use variable in SQL statement
  55. Live search from database table
  56. Processing ajax call to php to insert into mysql database
  57. WPDB secure custom form
  58. Query the links Database
  59. WordPress Custom Query: Combining Two Functions
  60. MySQL Query Returns Array () In Shortcode
  61. How to WP_Query posts order by parent title?
  62. Passing in MySQL prepare statement parameter separately throwing error
  63. Database SQL query error
  64. Display Results of SQL Query on WP site
  65. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  66. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  67. Updated Php version from 5.4 to 7.2 and getting “PHP installation missing the MySQL extension needed by WordPress”
  68. how to get data from two different table from wordpress database
  69. Passing Current User ID into SQL statement
  70. How to optimize and reduce excessive database queries
  71. How to display MySQL table data which is stored as an array?
  72. Store GA Client ID in User DB
  73. How to import woocommerce custom fields data into another site?
  74. PHP 7.2.18 | Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  75. Need help with format of nested array in MySQL
  76. Inserting other fields to existing registration form in a WordPress theme
  77. Advanced WordPress SQL Query
  78. Splitting table data to pages with numbers
  79. Site doesnt work once PHP changed to 7.1
  80. How to detect if a revision was made by woocommerce or wordpress?
  81. WordPress WPDB::insert 13th param is always blank (only if format)
  82. Ajax not updating to database
  83. can’t delete a row from post_meta table
  84. MySQL query in WordPress with AJAX
  85. Processing forms with php to wordpress database
  86. directorypress theme error mysql_error() [closed]
  87. How to connect database table to each registered wordpress user.
  88. retrieve wordpress post-meta using php not wordpress functions
  89. Splash pages on a high traffic site
  90. Using the same shortcode to show any table from the database
  91. Cannot Upload Custom Header Image into WordPress Dashboard
  92. I am unable to fetch json data from wp_db
  93. Submit cf7 form to cfdb as pdf/BLOB [closed]
  94. Parse error: syntax error, unexpected ‘}’ in C:\xampp\htdocs\admin\products.php on line 148 [closed]
  95. How to send push notification in android using php? [closed]
  96. Getting invalid user ID error when creating a new user with wp_insert_user
  97. Custom form that stores data in mysql database
  98. Putting form result in my database
  99. How can I update a value of a field depending on outside source?
  100. How to return count number from a wordpress database