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. Updates applied to staging WordPress site affecting production even with different databases
  2. Sudden Upload HTTP errors, PHP uploads and memory limits are already to high to my taste. Anything else?
  3. WordPress mysql deos not work with php7
  4. How can i limit the number of posts to the most recent 6 in my query?
  5. WordPress/NGINX not respecting the category URL for new posts
  6. Change upload URL by mime type
  7. PHP 7.2.18 | Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  8. autocomplete in wordpress using ajax with json-data
  9. Error inserting into custom table – Object of class wpdb could not be converted to string [closed]
  10. Windows Setup: Error establishing a database connection
  11. Need help with format of nested array in MySQL
  12. WP + MySql db / PHP
  13. The plugin generated 225 characters of unexpected output during activation
  14. Unexpected behavior when trying to manually install WordPress on macOS Sierra
  15. WordPress post insertion from PHP file
  16. Creating a WordPress addon for ContactForm7 submission (.XML file export)
  17. WAMP SERVER Command Prompt SET PATH=%PATH%
  18. Insert data from form to database
  19. append data to mysql table via submit button coded in php – not working
  20. New database entry to trigger runing PHP/SQL query through link with token, without logging into the website
  21. WordPress select query issue
  22. Inserting other fields to existing registration form in a WordPress theme
  23. Query doesn’t display text data with apostrophes
  24. (Who to follow) Twitter widget
  25. I want show only data for today
  26. Rewrite SQL query as a prepared statement and use in foreach loop
  27. How to do a MySql query in WordPress?
  28. Prepared DB Query from _POST array
  29. get/show Last ID
  30. Advanced WordPress SQL Query
  31. Splitting table data to pages with numbers
  32. How can get all users by current user meta (array)?
  33. Site doesnt work once PHP changed to 7.1
  34. Add two or multiple functions in WordPress Post or Page
  35. How to detect if a revision was made by woocommerce or wordpress?
  36. WordPress WPDB::insert 13th param is always blank (only if format)
  37. Ajax not updating to database
  38. SQL Query Search page
  39. How can I display a query in a page?
  40. can’t delete a row from post_meta table
  41. Include a custom field in mysql query
  42. How to solve 404 permalink errors on nginx server
  43. Send data from plugin to external database
  44. MySQL query in WordPress with AJAX
  45. Processing forms with php to wordpress database
  46. How to properly send many mysql queries via php and what happens with ajax requests after they are sent?
  47. Conditional statement within WP SQL query
  48. How to set max users to 17.000
  49. Passed variable gets undefined variable error on insert on next page
  50. directorypress theme error mysql_error() [closed]
  51. How to set up an auto delete post?
  52. divide custom field values in div every two values
  53. WordPress upload images not displaying
  54. MySQL queries in WordPress
  55. two wordpress sites, two themes, one database, same content
  56. how to check for wordpress Query errors
  57. Insert double entry in DB
  58. How to connect database table to each registered wordpress user.
  59. retrieve wordpress post-meta using php not wordpress functions
  60. WordPress plugin creating sidebar on the theme/page
  61. Splash pages on a high traffic site
  62. WordPress and magic quotes
  63. Using the same shortcode to show any table from the database
  64. Splitting One Big WordPress Site into Multiple Small Sites
  65. How to get WordPress Adminmenu items?
  66. Let users register weight each day and save it in DB
  67. How To Customize Position of »add to cart« of WooCommerce on Product Page [closed]
  68. MySql Query for WordPress
  69. MySQL database migration to WordPress
  70. Simple tree display of WordPress menu
  71. WordPress Pages into Sections edit.php PHP hack
  72. WordPress Plugin Receive a Link
  73. Cannot Upload Custom Header Image into WordPress Dashboard
  74. what is %variable% in a wordpress plugin? [closed]
  75. How to set variable to specific field when querying
  76. How to get a database field value from a WordPress table? [closed]
  77. Getting invalid user ID error when creating a new user with wp_insert_user
  78. Execute multiple PHP Snippets causes error?
  79. WordPress directories not writable after PHP version upgrade
  80. Custom form that stores data in mysql database
  81. Error resetting database index using ALTER TABLE in $wpdb->query
  82. Split Million WordPress Post’s Into Multiple Database Server
  83. Getting 504 Gateway Timeout Error on AWS Server! [closed]
  84. WordPress issue – data is not showing in wp-admin, but when searching through database, all the data is there
  85. what to do after instlling cyberpanel on VPS
  86. How can I improve and optimise my wordpress web server for better performance in 2023
  87. Putting form result in my database
  88. How can I update a value of a field depending on outside source?
  89. running an existing WordPress site from Visual Studio Code?
  90. Can’t insert into a database wordpress
  91. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax [closed]
  92. Global update of records after import WP All Import Pro
  93. WordPress site calling debug.log and .user.ini at certain hour
  94. NGINX rewrite rules for WordPress Subdirectory Multisite to support deep URL
  95. Help with creating commenting system using PHP, jQuery and AJAX
  96. WP-CLI PHP Deprecated Warning
  97. WordPress install on new server not recognising MariaDB version
  98. How to properly prepare a column name if passed to a stored procedure?
  99. How to return count number from a wordpress database
  100. Trying to GET data with ajax from database and show in fullcalendar
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)