Hi,
I am using NewsPaper on VPS with very good specs, but our website loading is too slow and there is many database queries coming from NewsPaper theme that slows down the server.
Here are the example of the slow queries :
| 15152 | news5r3o_l9s | localhost | news5r3o_l9s | Query | 0 | Sending data | SELECT SQL_CALC_FOUND_ROWS WFZ_posts.ID
FROM WFZ_posts LEFT JOIN WFZ_term_relationships ON ( | 0.000 |
| 15159 | news5r3o_l9s | localhost | news5r3o_l9s | Query | 1 | Sending data | SELECT SQL_CALC_FOUND_ROWS WFZ_posts.ID
FROM WFZ_posts LEFT JOIN WFZ_term_relationships ON ( | 0.000 |
| 15161 | news5r3o_l9s | localhost | news5r3o_l9s | Query | 1 | Sending data | SELECT SQL_CALC_FOUND_ROWS WFZ_posts.ID
FROM WFZ_posts LEFT JOIN WFZ_term_relationships ON ( | 0.000 |
| 15171 | news5r3o_l9s | localhost | news5r3o_l9s | Query | 1 | Sending data | SELECT SQL_CALC_FOUND_ROWS WFZ_posts.ID
FROM WFZ_posts LEFT JOIN WFZ_term_relationships ON ( | 0.000 |
| 15152 | news5r3o_l9s | localhost | news5r3o_l9s | Query | 0 | Sending data | SELECT SQL_CALC_FOUND_ROWS WFZ_posts.ID
FROM WFZ_posts LEFT JOIN WFZ_term_relationships ON ( | 0.000 |
| 15159 | news5r3o_l9s | localhost | news5r3o_l9s | Query | 1 | Sending data | SELECT SQL_CALC_FOUND_ROWS WFZ_posts.ID
FROM WFZ_posts LEFT JOIN WFZ_term_relationships ON ( | 0.000 |
| 15161 | news5r3o_l9s | localhost | news5r3o_l9s | Query | 1 | Sending data | SELECT SQL_CALC_FOUND_ROWS WFZ_posts.ID
FROM WFZ_posts LEFT JOIN WFZ_term_relationships ON ( | 0.000 |
| 15171 | news5r3o_l9s | localhost | news5r3o_l9s | Query | 1 | Sending data | SELECT SQL_CALC_FOUND_ROWS WFZ_posts.ID
FROM WFZ_posts LEFT JOIN WFZ_term_relationships ON ( | 0.000 |
Please help me to reduce the queries or to make the website more faster and not overload the server.
Hi,
What you can do is to use the flex block cache option and set it to at least 10 minutes, this should improve the results https://forum.tagdiv.com/use-flex-blocks-cache-option/
