A client contacted us to assist them in finding a solution for slow page times for their site.
All the pages of the site were slow, and taking 2.9 to 3.3 seconds.
Upon investigation, we found that one view was responsible for most of that time.
However, the query execution itself was fast, around 11 ms.
But, the views rendering time was obscenely high: 2,603.48 ms!
So, when editing the view, you would see this at the bottom:
Query build time 2.07 ms Query execute time 11.32 ms View render time 2,603.48 ms