Body: <p>We have been using civi live for a few months in a hosted environment. In response to concerns from the admin team I took some timings for common tasks and agree with them that performance is very disappointing. We intend to use a monitoring package to investigate but would be grateful for any views on the results below:</p>
  <ul>
  <li>search for a contact = 8 secs</li>
  <li>select edit a contact = 5 sec</li>
  <li>edit a contact field &lt;1 sec</li>
  <li>save edited contact = 8 sec</li>
  <li>edit a financial type = 5 sec</li>
  <li>edit a communication preference = 7 sec</li>
  <li>renew a membership = 3 secs</li>
  <li>edit greeting = 6 secs</li>
  <li>edit address = 8 secs</li>
  </ul>
  <p>The system is accessed over broadband and other services are fine.</p>
  <p>I realise there are many hardware, software, database issues that can affect performance but would be grateful for any comments on the general premise from administrators that they system is very slow.</p>
  <p>Thankyou</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-08-03T20:30:08.927Z
Comments.Text: Can you add some information about your hosted environment
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-08-04T08:17:45.363Z
Comments.Text: Since it's hosted, talk to your hosting provider.  Sometimes their performance monitoring can provide useful clues.  Is your CMS slow as well or just Civi?
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-08-04T14:54:45.727Z
Comments.Text: You could compare with the development sandboxes, which run on a virtual server with 4 GB ram: https://dmaster.demo.civicrm.org/
  
  The number of contacts & contributions will slow down searches. If using Drupal, make sure that the Watchdog is not clogged with warnings. The watchdog often kills performance.
Comments.UserDisplayName: bgm
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-08-16T20:25:52.337Z
Comments.Text: Thank you all. I have managed to view civi on a modest hosting environment giving much better performance so I think it is time to move to another hosting.
Comments.UserDisplayName: Dave Hassall
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-01-12T00:10:34.183Z
Comments.Text: Additional information request, please. 
  RAM size, # cores, any SSD or NVME devices on MySQL Host server? 
  Post on pastebin.com and share the links. 
  From your SSH login root, Text results of: 
  A) SELECT COUNT(*) FROM information_schema.tables;
  B) SHOW GLOBAL STATUS;    after minimum 24 hours UPTIME
  C) SHOW GLOBAL VARIABLES; 
  D) SHOW FULL PROCESSLIST; 
  G) SHOW ENGINE INNODB STATUS; 
  H) SELECT name, count FROM information_schema.innodb_metrics ORDER BY name; 
  for server workload tuning analysis to provide suggestions.
Comments.UserDisplayName: Wilson Hauck
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-01-19T09:13:03.347Z
Comments.Text: Thank you for your help. I do not have access to that information but have requested it from the relevant person.
Comments.UserDisplayName: Dave Hassall
Tags: <performance>
Title: performance of business functions
ThreadText: # performance of business functions
  
  (Asked by: username_0 on 2021-08-03)
  
  We have been using civi live for a few months in a hosted environment. In response to concerns from the admin team I took some timings for common tasks and agree with them that performance is very disappointing. We intend to use a monitoring package to investigate but would be grateful for any views on the results below:
  
  * search for a contact = 8 secs
  * select edit a contact = 5 sec
  * edit a contact field <1 sec
  * save edited contact = 8 sec
  * edit a financial type = 5 sec
  * edit a communication preference = 7 sec
  * renew a membership = 3 secs
  * edit greeting = 6 secs
  * edit address = 8 secs
  
  The system is accessed over broadband and other services are fine.
  
  I realise there are many hardware, software, database issues that can affect performance but would be grateful for any comments on the general premise from administrators that they system is very slow.
  
  Thankyou
  
  **Tags:** performance
  
  > **Comments:**
  > **username_1**: Can you add some information about your hosted environment  
  > **username_2**: Since it's hosted, talk to your hosting provider.  Sometimes their performance monitoring can provide useful clues.  Is your CMS slow as well or just Civi?  
  > **username_3**: You could compare with the development sandboxes, which run on a virtual server with 4 GB ram: https://dmaster.demo.civicrm.org/  The number of contacts & contributions will slow down searches. If using Drupal, make sure that the Watchdog is not clogged with warnings. The watchdog often kills performance.  
  > **username_0**: Thank you all. I have managed to view civi on a modest hosting environment giving much better performance so I think it is time to move to another hosting.  
  > **username_4**: Additional information request, please.  RAM size, # cores, any SSD or NVME devices on MySQL Host server?  Post on pastebin.com and share the links.  From your SSH login root, Text results of:  A) SELECT COUNT(*) FROM information_schema.tables; B) SHOW GLOBAL STATUS;    after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES;  D) SHOW FULL PROCESSLIST;  G) SHOW ENGINE INNODB STATUS;  H) SELECT name, count FROM information_schema.innodb_metrics ORDER BY name;  for server workload tuning analysis to provide suggestions.  
  > **username_0**: Thank you for your help. I do not have access to that information but have requested it from the relevant person.  
  
  ---
  
  ## 0 answers
  
  