https://community.qlik.com/t5/QlikView/QlikView-Loading-Slowly-due-to-VarChar-Data-Types/m-p/1568825#M597529 <P>I am currently having an issue when it comes to loading data from a View in SQL Server to a QlikView 12 Report. The view contains 2 specific columns that are VarChar(1000) which are causing the slowdown for users. The View currently&nbsp; holds 400 rows, however these two columns are 100% necessary for the report as they drive the report. When I remove the 2 columns from the view, the report loads just fine which is how I know it's the 2 columns that are causing the issue. The reload logs are telling me that the document is loading in 3 seconds, however I do not believe that to be the case.<BR /><BR />The report appears to have opened and loaded fully, however when a user goes to interact with filters or the report, nothing happens for at least 5 minutes. After roughly 5 minutes everything works normally. I need assistance in what to do in order to decrease this time.<BR /><BR />I have tried a few different work arounds including limiting these two columns to appear only when specific filters are selected. I have also tried modifying the reload script. Neither of these solutions solved my issue.</P><P>Does anyone have any suggestions or ideas?</P> Fri, 12 Apr 2019 14:41:00 GMT jjenkinsmontauk 2019-04-12T14:41:00Z https://community.qlik.com/t5/QlikView/QlikView-Loading-Slowly-due-to-VarChar-Data-Types/m-p/1568825#M597529 <P>I am currently having an issue when it comes to loading data from a View in SQL Server to a QlikView 12 Report. The view contains 2 specific columns that are VarChar(1000) which are causing the slowdown for users. The View currently&nbsp; holds 400 rows, however these two columns are 100% necessary for the report as they drive the report. When I remove the 2 columns from the view, the report loads just fine which is how I know it's the 2 columns that are causing the issue. The reload logs are telling me that the document is loading in 3 seconds, however I do not believe that to be the case.<BR /><BR />The report appears to have opened and loaded fully, however when a user goes to interact with filters or the report, nothing happens for at least 5 minutes. After roughly 5 minutes everything works normally. I need assistance in what to do in order to decrease this time.<BR /><BR />I have tried a few different work arounds including limiting these two columns to appear only when specific filters are selected. I have also tried modifying the reload script. Neither of these solutions solved my issue.</P><P>Does anyone have any suggestions or ideas?</P> Fri, 12 Apr 2019 14:41:00 GMT https://community.qlik.com/t5/QlikView/QlikView-Loading-Slowly-due-to-VarChar-Data-Types/m-p/1568825#M597529 jjenkinsmontauk 2019-04-12T14:41:00Z