topic Re: String Vs integer Values in QlikView https://community.qlik.com/t5/QlikView/String-Vs-integer-Values/m-p/427164#M159168 <HTML><HEAD></HEAD><BODY><P>Thanks for your response. I hope the same logic is applicable at the expression as well.</P></BODY></HTML> Fri, 05 Apr 2013 19:01:30 GMT brindlogcool 2013-04-05T19:01:30Z String Vs integer Values https://community.qlik.com/t5/QlikView/String-Vs-integer-Values/m-p/427162#M159166 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Integer comparison will be faster compared to string comparison. Is there any change in the performance if there are more distinct values or less distinct values.</P></BODY></HTML> Fri, 05 Apr 2013 16:20:58 GMT https://community.qlik.com/t5/QlikView/String-Vs-integer-Values/m-p/427162#M159166 brindlogcool 2013-04-05T16:20:58Z Re: String Vs integer Values https://community.qlik.com/t5/QlikView/String-Vs-integer-Values/m-p/427163#M159167 <HTML><HEAD></HEAD><BODY><P>A field with less distinct values will be better for performance than a field with more distinct values. For this reason it's recommended to split timestamp fields into a date and a time field for large tables. Low cardinality fields take up less memory and can be searched and sorted faster.</P></BODY></HTML> Fri, 05 Apr 2013 17:18:47 GMT https://community.qlik.com/t5/QlikView/String-Vs-integer-Values/m-p/427163#M159167 Gysbert_Wassenaar 2013-04-05T17:18:47Z Re: String Vs integer Values https://community.qlik.com/t5/QlikView/String-Vs-integer-Values/m-p/427164#M159168 <HTML><HEAD></HEAD><BODY><P>Thanks for your response. I hope the same logic is applicable at the expression as well.</P></BODY></HTML> Fri, 05 Apr 2013 19:01:30 GMT https://community.qlik.com/t5/QlikView/String-Vs-integer-Values/m-p/427164#M159168 brindlogcool 2013-04-05T19:01:30Z