3

I have created a Drupal Views block, which aggregates some CiviCRM values. This block I have on most pages.

How (if any) is this affecting the performance of the CiviCRM site?

(How does Drupal Views aggregate its result? SQL query?)

4

Views has an option to display the exact query it generates, so you can get a rough idea by running that query alone with a tool that allows you to time it. Ideally a single query should execute in a matter of milliseconds, not seconds.

If you have general concerns about sql performance, enable slow query logging to find out which queries on your site are taking the longest.

4

Views also offers 'caching' so you could set that if you do have proof that it is the View display that is slowing down your page load.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.