Recently I added a large amount of products to my WooCommerce site and noticed a significant slowdown (3-5 seconds). In particular on category pages that include layered navigation in the sidebar. I think this layered navigation requires a lot of database calls and that the database is the cause of the slowdown. Unfortunately a layered navigation is a must with this many products (and every single competitor has one).
The site runs on a VPS and according to the stats it has no problem at all with the load CPU/memory-wise. Which also leads me to believe this is a database issue.
I looked for some common fixes and removed some entries from posts that were deleted, removed some transient entries and optimized the tables through phpmyadmin. It helped a little, but not nearly enough. I simply don't know enough about databases to find and fix the problem. If it even is a database problem.
Here are the current load times:
(full pagespeed breakdown: http://i.imgur.com/hsRS2RE.png) (Yes, I still have to optimize the homepage images.)
The first request (GET Example Domain) is where the main problem is it seems:
Homepage: 0.95s, waiting time of 0.67s
Main category page: 2.57s, waiting time of 2.26s
Product page: 1.05s, waiting time 0.73s
Basically I need someone to take a look at my site/database to find (and ideally fix) the problem. So if anyone can help me with this or refer me to someone that can, I would really appreciate it. I have no problem with hiring someone, but I would rather work with a gay webmaster/referral than go through Odesk and the likes.
The site runs on a VPS and according to the stats it has no problem at all with the load CPU/memory-wise. Which also leads me to believe this is a database issue.
I looked for some common fixes and removed some entries from posts that were deleted, removed some transient entries and optimized the tables through phpmyadmin. It helped a little, but not nearly enough. I simply don't know enough about databases to find and fix the problem. If it even is a database problem.
Here are the current load times:
(full pagespeed breakdown: http://i.imgur.com/hsRS2RE.png) (Yes, I still have to optimize the homepage images.)
The first request (GET Example Domain) is where the main problem is it seems:
Homepage: 0.95s, waiting time of 0.67s
Main category page: 2.57s, waiting time of 2.26s
Product page: 1.05s, waiting time 0.73s
Basically I need someone to take a look at my site/database to find (and ideally fix) the problem. So if anyone can help me with this or refer me to someone that can, I would really appreciate it. I have no problem with hiring someone, but I would rather work with a gay webmaster/referral than go through Odesk and the likes.