Non-English Locale Causes Slow Performance Viewing Issue in JIRA IFrame
Opening an issue in the JIRA IFrame with English locale works well. However, if using other non-English locale, it will take a long time (e.g. 20 seconds) to display the issue in the JIRA IFrame.
The performance is not related with the IFrame itself. The IFrame is just calling the standard issue view. There is no logic being processed. The root cause of the problem is the character encoding of the JIRA instance or the database itself.
Please ensure you had done the following:-
- Encoding setting for JVM
Change encoding used by JVM by appending -Dfile.encoding=utf-8 to your application start up parameters. You can refer to the following documentation as a guideline: Setting Properties and Options on Startup.
- General Configuration has been set to UTF-8.
You can check this via Administration > Global Settings > General Configuration whether the character encoding has been set to utf8.
JIRA database is configured in UTF8.
You can try using the following command to see what character encoding is set for the database:
use jiradb; status; show variables like '%char%';
If the result is not shown as UTF8, you need to reconfigure your MySQL by running the MySQL Server Instance Configuration Wizard and select utf8 as the default character set/collation. After the setting, restart MySQL and see that fixes the problem.