CiviCRM Community Forums (archive)

Hi,

Find that generating a profile is super slow sometimes (and as I need it for petition signatures, it might end up being hammered, it has to be fast), before investigating caching, was wondering if there is a "profile/debug plugin" (a bit like for drupal):

Eg, you can add (visible only to admin) a block that displays

#of sql requests
#sql time
#total time

Does it exists? If not, will try modifying the DAO to add the counter (hack/proof of concept)

Cool, found a hot spot I think: When using the profiles, seem that quite a few similar requests are called several time.

eg: this is called 50 times:

SELECTIF ( civicrm_email.location_type_id IS NULL, IF ( civicrm_address.location_type_id IS NULL, IF ( civicrm_phone.location_type_id IS NULL, IF ( civicrm_im.location_type_id IS NULL, IF ( civicrm_openid.location_type_id IS NULL, null, civicrm_openid.location_type_id) ,civicrm_im.location_type_id) ,civicrm_phone.location_type_id) ,civicrm_address.location_type_id) ,civicrm_email.location_type_id) as locationType FROM civicrm_contact LEFT JOIN civicrm_email ON ( civicrm_email.is_primary = 1 AND civicrm_email.contact_id = civicrm_contact.id ) LEFT JOIN civicrm_address ON ( civicrm_address.is_primary = 1 AND civicrm_address.contact_id = civicrm_contact.id) LEFT JOIN civicrm_phone ON ( civicrm_phone.is_primary = 1 AND civicrm_phone.contact_id = civicrm_contact.id) LEFT JOIN civicrm_im ON ( civicrm_im.is_primary = 1 AND civicrm_im.contact_id = civicrm_contact.id) LEFT JOIN civicrm_openid ON ( civicrm_openid.is_primary = 1 AND civicrm_openid.contact_id = civicrm_contact.id) WHERE civicrm_contact.id = 1

and this as well.

SELECT v.name as name ,v.value as value, v.grouping as grouping FROM civicrm_option_value v, civicrm_option_group g WHERE v.option_group_id = g.id AND g.name = 'address_options' AND v.is_active = 1 AND g.is_active = 1 ORDER BY v.weight

Is there an option to display the call stack ? Right now, it says that the function is executeQuery, that doesn't come as a surprise, but doesn't help to find