topic Optimize and Dynamic Load of QVDs in QlikView https://community.qlik.com/t5/QlikView/Optimize-and-Dynamic-Load-of-QVDs/m-p/678024#M245961 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>We are currently working on a telecom project which deals with millions of records per day.&nbsp; This main purpose for the project is to Search the data from the ListBoxes and display the results in TextBoxes.&nbsp; </P><P>We are extracting the data from MSSQL Database</P><P></P><P>My queries are as follows:</P><P>1. The data reload is to happen every 10-20 mins</P><P>2. What is the best way to optimize QVDs (using incremental QVDs)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; * Should we use monthly QVDs (approx. 30 million rows per month).&nbsp; How can we use this in conjunction with incremental load?</P><P>3. I have seen that when the data is large it takes time displaying it in ListBoxes and TextBoxes</P><P>4. How can we dynamically show the data (Dynamic Update?).&nbsp; Only load and show data when the user selects from any criteria?</P><P>5. Any other advice on dealing and displaying large data will be helpful.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 08 Oct 2014 06:58:52 GMT sjhussain 2014-10-08T06:58:52Z Optimize and Dynamic Load of QVDs https://community.qlik.com/t5/QlikView/Optimize-and-Dynamic-Load-of-QVDs/m-p/678024#M245961 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>We are currently working on a telecom project which deals with millions of records per day.&nbsp; This main purpose for the project is to Search the data from the ListBoxes and display the results in TextBoxes.&nbsp; </P><P>We are extracting the data from MSSQL Database</P><P></P><P>My queries are as follows:</P><P>1. The data reload is to happen every 10-20 mins</P><P>2. What is the best way to optimize QVDs (using incremental QVDs)</P><P>&nbsp;&nbsp;&nbsp;&nbsp; * Should we use monthly QVDs (approx. 30 million rows per month).&nbsp; How can we use this in conjunction with incremental load?</P><P>3. I have seen that when the data is large it takes time displaying it in ListBoxes and TextBoxes</P><P>4. How can we dynamically show the data (Dynamic Update?).&nbsp; Only load and show data when the user selects from any criteria?</P><P>5. Any other advice on dealing and displaying large data will be helpful.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 08 Oct 2014 06:58:52 GMT https://community.qlik.com/t5/QlikView/Optimize-and-Dynamic-Load-of-QVDs/m-p/678024#M245961 sjhussain 2014-10-08T06:58:52Z