Answers.Body: <ol>
  <li><p>How many activities do you have (i.e. the number of rows in the activity table)</p></li>
  <li><p>Where are you hosting the site</p></li>
  <li><p>Is your database on the same server as the web server</p></li>
  </ol>
  
  <p>If i had to guess, i suspect your activity table is quite large and the left join with the contact tables is basically causing the query to take forever and hence the timeout</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-11T09:18:15.027Z
Answers.Text: Hi donald, thanks for replying. I have 24,000 activities. If I search for activities with type "bulk email" then the search times out, but it doesn't for any other activity search. But there are only 24 bulk email type activities in the database. The database is on the same server as the web server. I am hosting the site on Layershift.
Answers.UserDisplayName: TheBarnacle
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-08T15:06:28.537Z
Answers.LastActivityDate: 2015-05-08T15:06:28.537Z
Answers.UserDisplayName: Donald Lobo
Body: <p>I am using CiviCRM 4.5.8, an instance with 18,328 contacts.</p>
  
  <p>No matter how long I set the max execution time of a page, I am getting a timeout when trying to view the constituent detail report (instance 2). The other reports all work fine. </p>
  
  <p>Has anyone ever experienced this? Can anyone think of a reason this might be happening? The PHP error logs are showing nothing but a timeout, and the CiviCRM log is showing nothing. </p>
  
  <p><strong>Update:</strong> It seems to be related to Activities. If I create a new report based on constituent detail, and uncheck all the activity columns from being used, then the report is produced ok. If I check one column to do with activities again, then it stops working and times out. </p>
  
Tags: <civireport>
Title: constituent detail report not working (timeout)
ThreadText: # constituent detail report not working (timeout)
  
  (Asked by: username_0 on 2015-05-08)
  
  I am using CiviCRM 4.5.8, an instance with 18,328 contacts.
  
  No matter how long I set the max execution time of a page, I am getting a timeout when trying to view the constituent detail report (instance 2). The other reports all work fine.
  
  Has anyone ever experienced this? Can anyone think of a reason this might be happening? The PHP error logs are showing nothing but a timeout, and the CiviCRM log is showing nothing.
  
  **Update:** It seems to be related to Activities. If I create a new report based on constituent detail, and uncheck all the activity columns from being used, then the report is produced ok. If I check one column to do with activities again, then it stops working and times out.
  
  **Tags:** civireport
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-05-08. Score: 1
  
  1. How many activities do you have (i.e. the number of rows in the activity table)
  2. Where are you hosting the site
  3. Is your database on the same server as the web server
  
  If i had to guess, i suspect your activity table is quite large and the left join with the contact tables is basically causing the query to take forever and hence the timeout
  
  > **Comments:**
  > **username_0**: Hi donald, thanks for replying. I have 24,000 activities. If I search for activities with type "bulk email" then the search times out, but it doesn't for any other activity search. But there are only 24 bulk email type activities in the database. The database is on the same server as the web server. I am hosting the site on Layershift.  
  
  ---
  
  