Very fast but still too much SQL!
-
Hi Mikael,
After a lot of reworking, we got 120,000 Woocommerce products indexed and page loads have come down from 3 weeks to 3 seconds. We deactivated some widgets and plugins and could see the speed increase as we did so. But we’re still seeing 200 – 300 SQL Selects/Inserts/Updates, much of it to the options table (mainly inserts/updates).
Having looked at your code, you’re trying to hijack WP-Query as often as possible but it looks like some post_types may be problems, such as nav_menu_item.
The profiler works really well (great when you get to the bottom and see 1 Elastic query!) but any ideas on tracking these remaining SQL statements?
BTW, brilliant plugin! Have now given up on my SOLR plugin!
Regards,
David Q
- The topic ‘Very fast but still too much SQL!’ is closed to new replies.
