Large Woocommerce Site (83,000 items), What Can I Do? [closed]

Did either of you solve your issues with Woocommerce being slow?

After some profiling, I determined it was PHP being slow, not SQL.

Total query time: 0.05915s for 89 queries.
Page generated in 22.00653s (99.73% PHP, 0.27% MySQL)

With that info, nothing you change in the front end is going to solve anything.

Related Posts:

  1. dbDelta support for FOREIGN KEY
  2. is it possible to run some php code within a wordpress page?
  3. How to correctly submit a search form and display the result in an independent page
  4. How to use update and delete query in wordpress
  5. How to implement WP_List_Table? WP_List_Table giving array instead of a value in listing table
  6. Does WordPress cache get_user_meta() results?
  7. WordPress widget in custom theme
  8. Using Echo in ShortCode – Stuck
  9. MySQL query performed 4 times inside loop
  10. Show only one post for each author ( Page loads too slow )
  11. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  12. Bulk Image upload and one image for each post?
  13. Modern Tribe Calendar wp-query with meta query not working at all
  14. WP database error for comments_popup_link()
  15. No wp-config.php file on local install of wordpress – site still displays
  16. Use ajax to update_post_meta
  17. Mysterious HTTP 404 header in my own scripts
  18. Woocommerce Custom CSV export
  19. Insert all post IDs in new database table
  20. Is the outdated PHP mysql extension a requirement for WordPress 4.6?
  21. PHP Code stuck in Cache [Memcached] [closed]
  22. What SQL / WordPress queries would need a nonce?
  23. Different database query in function.php using mysqli
  24. Adding a div at the bottom of a sidebar
  25. Why is variable not working on custom sql query using wpdb?
  26. Get WooCommerce product details and transfer them to a custom DB table
  27. How can I export posts with featured images, without download them
  28. How to securely provide a $_POST var in WP_Query with PHP 7?
  29. Create WP_Query to search for posts by their categories or their parent/child categories
  30. What is a valid parent for get_terms()?
  31. WSoD being caused by this piece of code
  32. Working with wordpress plugin and theme templates structures
  33. WordPress: Access a plugin from within a theme
  34. How to display data from custom table in wordpress phpmyadmin
  35. Calculating a large number of MYSQL queries as customshort codes, slow
  36. WpDataTables – View Image Directory
  37. Update results, Before deleting the related category [closed]
  38. Sum the total amount of a specific product purchased per user and display in table
  39. Incorrect MIME type for assets with Valet
  40. Replacing mysql_escape_string in a custom plugin when moving to PHP7
  41. Weird 404 URL Problem – domain name being placed at end of urls
  42. database sent to a JSON file
  43. NGINX rewrite rules for multisite
  44. Woocommerce Show Single Product on Homepage
  45. WordPress add_rewrite_rules for custom URLs ending in .html
  46. Make a database query using WordPress
  47. Should i use the wordpress Options table or to create database table..?
  48. Force Users To Relogin
  49. Basic wpdb update question
  50. How can I fetch data from another website to my wordpress website with mysql database
  51. A $_POST should occur when submit form but is not?
  52. Pull MySQL data from multiple tables and merge into 1 PHP array
  53. Using wordpress function to retrieve data
  54. form $_post action value gets truncated after it passes through two forms
  55. Adding data to custom wordpress database table
  56. Add row to custom database Table and delete all rows older than 1 day
  57. select a single val though a table in wordpress
  58. making php value numeric
  59. Woocommerce getting top level category parent and make all sub categories have the same template and menu
  60. Migrating site, only header shows
  61. populate select options from extra mysql table data
  62. Removal of all posts content in bulk, keeping the posts itself
  63. How to store checkbox data for individual users?
  64. How to get the custom field value using SQL query
  65. Please help! I have a problem with getting wordpress databas
  66. How to run complex query using PHP
  67. Usermeta data unserialize, extract and display in table in WordPress
  68. Conditional formatting on data fetched from MYSQL
  69. Can I split a huge wp_postmeta table across different databases or servers?
  70. I can’t separate the array by commas
  71. How much PHP and MySQL or MariaDB knowledge should I know to start writing WordPress themes and plug-ins and whatever else a beginner can edit?
  72. Sudden Upload HTTP errors, PHP uploads and memory limits are already to high to my taste. Anything else?
  73. WordPress mysql deos not work with php7
  74. How can i limit the number of posts to the most recent 6 in my query?
  75. WordPress/NGINX not respecting the category URL for new posts
  76. Error inserting into custom table – Object of class wpdb could not be converted to string [closed]
  77. WP + MySql db / PHP
  78. The plugin generated 225 characters of unexpected output during activation
  79. Creating a WordPress addon for ContactForm7 submission (.XML file export)
  80. append data to mysql table via submit button coded in php – not working
  81. WordPress select query issue
  82. (Who to follow) Twitter widget
  83. How to do a MySql query in WordPress?
  84. Add two or multiple functions in WordPress Post or Page
  85. How can I display a query in a page?
  86. Send data from plugin to external database
  87. How to set max users to 17.000
  88. Passed variable gets undefined variable error on insert on next page
  89. directorypress theme error mysql_error() [closed]
  90. How to set up an auto delete post?
  91. MySql Query for WordPress
  92. Cannot Upload Custom Header Image into WordPress Dashboard
  93. MySQL update text field with ‘
  94. How can I list only Subcategories in Woocommerce
  95. Predefine Magazine Style Layouts
  96. Parse error: syntax error, unexpected ‘}’ in C:\xampp\htdocs\admin\products.php on line 148 [closed]
  97. what is %variable% in a wordpress plugin? [closed]
  98. How to set variable to specific field when querying
  99. How to get a database field value from a WordPress table? [closed]
  100. Split Million WordPress Post’s Into Multiple Database Server