I am trying to get json response from my drupal7 site using Views.

Example : www.mysite.com/company company refers to a view which was created using json document

I also applied caching to the Company view as shown below enter image description here

Yet, It is taking much time to load the web service. (nearly 8 sec). total records are around 200 posts. Further, the records will be increased to more number.

I also tried Boost module and set max and min time for cache to 1 hour and 0 sec. But still same problem.

I also edited .htacces file.

Can anyone suggest any solution so that i can enhance the performance of the site as well as mobile app.

Thank you

  • How big is the body of the response in bytes? Are you using aggregation in the view?
    – Nic
    Commented Mar 7, 2013 at 16:53
  • Yes i am using aggregation
    – Ramaraju.d
    Commented Mar 8, 2013 at 12:47
  • I'm having a similar problem and am thinking aggregation may be part of the problem. I tried installed the Entity cache module to see if that would speed up the JSON generation, but not noticed an improvement. Is the output user-specific?
    – Nic
    Commented Mar 8, 2013 at 12:50
  • Yes, It is user specific. I too tried Entity Cache but no luck. planning to write queries on my own instead of views
    – Ramaraju.d
    Commented Mar 8, 2013 at 13:01


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.