2 Replies Latest reply: Jul 28, 2011 1:04 PM by Donald Posthuma RSS

    Limiting SQL load in script to improve performance

    Donald Posthuma

      To improve the performance of the load script I wan't to partially load the new data from the SQL database and the old data from QVD files. Is there way to terminate a SQL load based on a certain treshold. In the example below the while statement is not working but gives an idea into what I want to achieve.

       

      LOAD BookInventoryID

          WHERE BookInventoryID < 50000;

      SQL SELECT BookInventoryID

      WHILE BookInventoryID < 50000       //Statement to terminate SQL load when boundary is reached

      FROM DPAR.dbo.BookInventory

      ORDER BY BookInventoryID ASC;     //Order records ascending so only first part of the data is evaluated

       

       

      If you think this is not possible please reply so I can try something different. Thanks!