CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Performance Activiy field "Assign to"
Pages: [1]

Author Topic: Performance Activiy field "Assign to"  (Read 896 times)

brouwser

  • I’m new here
  • *
  • Posts: 22
  • Karma: 1
Performance Activiy field "Assign to"
October 26, 2010, 05:24:49 am
We've added 25000 contacts to our Civi (3.2.3) database and we use activities by themselves and activities in cases a lot. The field "Assign to" generates a selection of contacts to select from while typing. When using Internet Explorer 7 it takes 30-60 seconds to get a list to choose from. In firefox, on a linux machine, it takes a little less long but somewhere around 20-40 seconds. IE blocks completely during that time. Most of the time, unless you type really fast, it accepts three characters before it gets stuck.

The search box (in the top left hand corner) uses Ajax too but that performs a lot faster, as does the field "Find target contact" on the New Relationship form (instantly).

We had a similar size db in 3.1.5 and the problem there existed also but less bad. In 3.2.3 it has become a real problem.

Does anyone have a similar experience and / or advise to improve this?


Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Performance Activiy field "Assign to"
October 26, 2010, 10:06:37 am

hey erikb:

seems like an awful query being run for that ajax snippet. any chance we can get ssh access to the machine and/or the DB so we can reporduce and figure out how to write more optimized SQL for that case?

ping us on IRC

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Performance Activiy field "Assign to"
October 27, 2010, 05:28:18 am
Hi Lobo,
will ping you later on IRC to get that access arranged, I have permission from the project manager :-)
Erik
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Performance Activiy field "Assign to"
October 27, 2010, 06:50:50 am
Might be related to this one:

http://issues.civicrm.org/jira/browse/CRM-6825

eg. missing LIMIT

Also, Erik, if you take out the search on email, it avoids a join without index (costs 500ms on a 5kdb ), that's a workaround, but improves

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Performance Activiy field "Assign to"
October 27, 2010, 08:15:35 am
I will have a try with that, thanx!
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Performance Activiy field "Assign to"
October 28, 2010, 04:06:28 am
The patch at http://issues.civicrm.org/jira/browse/CRM-6825 did the job, no problems now! If the customer needs it we can always make the LIMIT a little bigger.
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Performance Activiy field "Assign to"
October 28, 2010, 02:23:55 pm
@lobo, can you reassign the patch to 3.2 or 3.3 ?

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Performance Activiy field "Assign to"
October 28, 2010, 04:34:19 pm

done. we'll add it in for 3.3

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Performance Activiy field "Assign to"

This forum was archived on 2017-11-26.