CiviCRM Community Forums (archive)

I just profiled a couple of pages & found that 20% & 40% of the 2 pages I profiled was spent on the crm_translate function. I probably picked pages that were intensive in this function (campaign interview & contribution search - both multi-row functions)

But it strikes me that for single language websites doing no translation having 20% of page load time go into translating seems a bit of a waste. Would it be too ignorant to suggest having a constant that we could define that would cause the ts function to exit early?

Attached is the profile pic (just one I couldn't seem to load more)

Hi,

Harmut made a couple of comments about gettext on IRC, don't know if he followed it up with you. From memory, gettext was loading more stuff than necessary and the api was loading translation even so they aren't any UI to translate.

Try to catch him on IRC, he's likely to have more details

X+

NB changing

CRM_Core_I18n::strarg($str)
 to

CRM_Core_I18n::strarg(&$str)


wouldn't hurt

Of the remaining 14 seconds :

4 secs are spent  running this query 225times (20 ms each)

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 g.is_active = 1 AND v.is_active = 1 ORDER BY v.weight

1 is  spent running  this query 45 times for each of the 5 fields:
SELECT * FROM civicrm_custom_field WHERE ( civicrm_custom_field.id = 121 )

a bit less is spent running this query 45 times

SELECT v.label as label ,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.id = 110 AND v.is_active = 1 AND g.is_active = 1 ORDER BY v.weight, v.label;


I've attached a pic of what the profile looks like - ignore the percentages - but note that in CRM_Core_optionGroup::values - the cacheget doesn't seem to be working as the query above this is the one being called there over & over

If you look at that pic above there are 4 functions with the word 'value' in them showing. 3 of them are guilty for the queries I pasted above ...

Perhaps this is a clue to why the caching isn't working - from another function - could the key be too long


        if ( strlen( $cacheKey ) > 40 ) {
            $cacheKey = md5( $cacheKey );
        }

Also - running pledge summary report - this query runs 32 times

SELECT v.label as label ,
v.value as value
FROM civicrm_option_value v, civicrm_option_group g WHERE v.option_group_id = g.id AND g.name = 'contribution_status'
AND g.is_active = 1
AND v.value = 2
AND v.is_active = 1

AND this one - 18 times

SELECT v.label as label ,v.value as value FROM civicrm_option_value v, civicrm_option_group g WHERE v.option_group_id = g.id AND g.name = 'contribution_status' AND g.is_active = 1
AND v.value = 6 AND v.is_active = 1

Probably an easier place to see them than the interview screen

& this one on

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

on

            $addressOptions = CRM_Core_BAO_Preferences::valueOptions( 'address_options' );

not being cached