1 Reply Latest reply: Feb 22, 2017 1:10 PM by Ali Ahmad RSS

    QDF Generator app loads very slow & opens data load editor very slow

    Ali Ahmad

      Hi,

       

      I've used the script for the QVD generator from the example container in Qlik Deployment Framework and was wondering if there is any issues with using this that anyone knows of? The Extract App becomes very slow after a while to open and also to open the data load editor and I can't seem to understand why.

       

      Here is the script:

       

      // ----------------------------------------

      // Load the Customer data

      // ----------------------------------------

      LET vL.TableName='Customers';

      LET vL.before=now();

       

      [$(vL.TableName)]:

      SQL SELECT *

      FROM [$(vL.TableName)];

       

      // ----------------------------------------

      // Write out the QVD to the defined path

      // ----------------------------------------

      comment table [$(vL.TableName)] with 'Level2,CustomerData';  //Comment table

      STORE [$(vL.TableName)] INTO '$(vL.QVDPath)\$(vL.TableName).qvd';

      Call IndexAdd('$(vL.QVDPath)\$(vL.TableName).qvd'); // Add Index for the northwind database

       

      // ----------------------------------------

      // Create statistical data

      // ----------------------------------------

      LET vL.after=now();

      LET vL.TableNumber=$(vL.TableNumber)+1;

      let vL.TableName_$(vL.TableNumber) ='$(vL.TableName)';

      let vL.NoOfRows_$(vL.TableNumber) = NoOfRows('$(vL.TableName)');

      let vL.NoOfFields_$(vL.TableNumber) = NoOfFields('$(vL.TableName)');

      let vL.TableTime_$(vL.TableNumber) =time(Timestamp('$(vL.after)') - timestamp('$(vL.before)'),'hh:mm:ss');

      // *****************************************;

      // Drop table;

      //*****************************************;

      DROP Table [$(vL.TableName)];

      trace 'Dropped Table $(vL.TableName)';