Answers.Body: <p>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.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-21T20:22:42.523Z
Answers.LastActivityDate: 2015-10-21T20:22:42.523Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>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.</p>
  
  <p>If you have general concerns about sql performance, enable slow query logging to find out which queries on your site are taking the longest.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-10-21T15:21:15.607Z
Answers.LastActivityDate: 2015-10-21T15:21:15.607Z
Answers.UserDisplayName: Coleman
Body: <p>I have created a Drupal Views block, which aggregates some CiviCRM values. This block I have on most pages.</p>
  
  <p>How (if any) is this affecting the performance of the CiviCRM site?</p>
  
  <p>(How does Drupal Views aggregate its result? SQL query?)</p>
  
Tags: <drupal-views>
Title: Is Drupal Views affecting CiviCRM performance?
ThreadText: # Is Drupal Views affecting CiviCRM performance?
  
  (Asked by: username_0 on 2015-10-20)
  
  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?)
  
  **Tags:** drupal-views
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-10-21. Score: 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.
  
  
  ---
  
  ### Answer by username_2 on 2015-10-21. Score: 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.
  
  
  ---
  
  