Why does ShortPixel make a lot of MySQL queries? Should I worry?
The short answer is: NO! :-)
When you're using a WordPress pluing like Query Monitor you may notice many queries made by ShortPixel
While the number of queries may seem like a lot this shouldn't worry you and here's why:
- unless you explicitly choose to have the image optimization triggered in the front end as well, the queries are only ran when visiting the /wp-admin page with a user role that allows image optimization
- the queries are run only when on certain pages that are related to images or ShortPixel settings
- the queries are highly optimized and sometimes there are many of them because otherwise, having less queries, would mean that the impact on MySQL and server memory would be bigger
- most of the queries are executed either when Bulk ShortPixel is running or when some new images where added and the image optimization process is automatically triggered