On my Drupal 7 site I have some heavy performance problems. I found out (with XHProf) that the cause of that problem are some Views. The strange thing is: not the query build time nor the query execute time are to slow, but the views rendering time:
Query build time 4.83 ms Query execute time 3.29 ms View render time 1175.82 ms
The view is complicated because it has 7 relations. So that its build and execute time is as long as it actually shows up in the example above, is what one would expect. But the rendering can not depend on the complexity of the query, right? But only on the complexity of the resulting array or something else. So, my question is, where to start to optimize View render time?
ps.: If the view is cached it much faster. But I have to optimize its over all execution time, when it's not cache or can't be cached.