topic Web Log Analysis in QlikView https://community.qlik.com/t5/QlikView/Web-Log-Analysis/m-p/563151#M693545 <HTML><HEAD></HEAD><BODY><P>I have successfuly built an application that reads and parses Microsoft IIS Logfiles.&nbsp; My question is about how to optimize performance when loading new data multiple times during the day?</P><P></P><P>The current application reads new log file transactions that do not exist in the current log and then concatenates them to create a new version of the log file.&nbsp; However, reloading the current log file, concatenating new transactions, and saving a new log file runs a good amount of time due to the fact that we have many servers and log file transactions.</P><P></P><P>I have just started reading about dynamic updates, but I am not sure that this is a good direction to pursue.&nbsp; </P><P></P><P>Does anyone have an practical experience with refreshing a log file dashboard multiple times during the day?&nbsp; Our VP has even mentioned an hourly refresh.&nbsp; </P><P></P><P>A second question involves scripting to rebuild the entire log file from scratch, in the event of "corruption" of some sort.&nbsp; Is this better to do in a completely separate QVW or combine into a single script with parameters?</P><P></P><P>Jerry</P></BODY></HTML> Wed, 07 Aug 2013 13:32:57 GMT Anonymous 2013-08-07T13:32:57Z Web Log Analysis https://community.qlik.com/t5/QlikView/Web-Log-Analysis/m-p/563151#M693545 <HTML><HEAD></HEAD><BODY><P>I have successfuly built an application that reads and parses Microsoft IIS Logfiles.&nbsp; My question is about how to optimize performance when loading new data multiple times during the day?</P><P></P><P>The current application reads new log file transactions that do not exist in the current log and then concatenates them to create a new version of the log file.&nbsp; However, reloading the current log file, concatenating new transactions, and saving a new log file runs a good amount of time due to the fact that we have many servers and log file transactions.</P><P></P><P>I have just started reading about dynamic updates, but I am not sure that this is a good direction to pursue.&nbsp; </P><P></P><P>Does anyone have an practical experience with refreshing a log file dashboard multiple times during the day?&nbsp; Our VP has even mentioned an hourly refresh.&nbsp; </P><P></P><P>A second question involves scripting to rebuild the entire log file from scratch, in the event of "corruption" of some sort.&nbsp; Is this better to do in a completely separate QVW or combine into a single script with parameters?</P><P></P><P>Jerry</P></BODY></HTML> Wed, 07 Aug 2013 13:32:57 GMT https://community.qlik.com/t5/QlikView/Web-Log-Analysis/m-p/563151#M693545 Anonymous 2013-08-07T13:32:57Z