topic Performance issues with translated column labels in straight tables in QlikView https://community.qlik.com/t5/QlikView/Performance-issues-with-translated-column-labels-in-straight/m-p/379691#M494745 <HTML><HEAD></HEAD><BODY><P>Hello everybody,</P><P></P><P>I am currently developing a multilingual dashboard and am experiencing performance issues when displaying straight tables.</P><P>I implemented the translations as an island table with one column per language, so each table row carries a label like this:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1345577323017203" jivemacro_uid="_1345577323017203"><P>=Only({&lt;TextKey={84}&gt;} [$(sLanguage)])</P></PRE><P></P><P>To pin down the cause of the slow refresh of my tables, I created two versions of a table which were identical except for the labels which were multilingual in the first case and simple text in the second case. I put both into a container and manually measured the average time it took for the redraw of the table to complete after I clicked the table's tab in the container.</P><P></P><P>Based on these experiments, it seems that about 50% of the total table redraw time (0.7 seconds for the table without translations, 1.4 for the translated one) are caused by the translated labels.</P><P></P><P>I also tried another translation approach by concatenating all my translation table entries into a variable and picking the right translated statement like this:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13455781014494789" jivemacro_uid="_13455781014494789"><P>=Pick(3, $(sTranslationList))</P></PRE><P>However, this approach was only faster than the first one for a small number of translated items (&lt;70).</P><P></P><P>Has anyone else had similar problems and suggestions on how to include the translations in a way that doesn't have such a huge impact on performance?</P></BODY></HTML> Tue, 21 Aug 2012 19:44:16 GMT 2012-08-21T19:44:16Z Performance issues with translated column labels in straight tables https://community.qlik.com/t5/QlikView/Performance-issues-with-translated-column-labels-in-straight/m-p/379691#M494745 <HTML><HEAD></HEAD><BODY><P>Hello everybody,</P><P></P><P>I am currently developing a multilingual dashboard and am experiencing performance issues when displaying straight tables.</P><P>I implemented the translations as an island table with one column per language, so each table row carries a label like this:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1345577323017203" jivemacro_uid="_1345577323017203"><P>=Only({&lt;TextKey={84}&gt;} [$(sLanguage)])</P></PRE><P></P><P>To pin down the cause of the slow refresh of my tables, I created two versions of a table which were identical except for the labels which were multilingual in the first case and simple text in the second case. I put both into a container and manually measured the average time it took for the redraw of the table to complete after I clicked the table's tab in the container.</P><P></P><P>Based on these experiments, it seems that about 50% of the total table redraw time (0.7 seconds for the table without translations, 1.4 for the translated one) are caused by the translated labels.</P><P></P><P>I also tried another translation approach by concatenating all my translation table entries into a variable and picking the right translated statement like this:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13455781014494789" jivemacro_uid="_13455781014494789"><P>=Pick(3, $(sTranslationList))</P></PRE><P>However, this approach was only faster than the first one for a small number of translated items (&lt;70).</P><P></P><P>Has anyone else had similar problems and suggestions on how to include the translations in a way that doesn't have such a huge impact on performance?</P></BODY></HTML> Tue, 21 Aug 2012 19:44:16 GMT https://community.qlik.com/t5/QlikView/Performance-issues-with-translated-column-labels-in-straight/m-p/379691#M494745 2012-08-21T19:44:16Z