View Issue Details

IDProjectCategoryView StatusLast Update
0018235phplist applicationInternationalization (l18n)public25-07-16 21:29
Reportersamtuke 
PrioritynormalSeverityminorReproducibilityhave not tried
Status resolvedResolutionfixed 
Product Version 
Target VersionFixed in Version3.2.6 
Summary0018235: Improve performance of I18n: improve caching
DescriptionLocalisation-related calls (looking up strings and fetching translations) is one of the most frequent and resource-intensive parts of phpList. Investigate current session-caching setup, and find where and why caching isn't being used.

See attached cachegrind files for breakdown of L18N calls (open these files with kcachegrind).

See also this performance report in New Relic:
https://rpm.newrelic.com/accounts/712719/applications/3635196/datastores#/overview/MySQL/drilldown?metric=Datastore%252Fstatement%252FMySQL%252Fphplist_i18n%252Fselect
TagsNo tags attached.

Activities

samtuke

22-07-16 13:15

administrator  

cachegrind.out.27131 (686,923 bytes)

samtuke

22-07-16 13:15

administrator  

cachegrind.out.27012 (801,354 bytes)

michiel

25-07-16 21:29

manager   ~0058055

I think this will do it.

https://github.com/phpList/phplist3/commit/e7dd2a814275dc84aee089e3fb87074061e5ccaa