Limiting SQL load in script to improve performance
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.
WHERE BookInventoryID < 50000;
SQL SELECT BookInventoryID
WHILE BookInventoryID < 50000 //Statement to terminate SQL load when boundary is reached
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!