Projects:Selector Performance Improvements/QA

Automatic Tests

This project will not include new automatic tests. The changes introduced for selectors must be transparent, so with the current test infrastructure should be enough.

Manual Tests

One of the most important conditions that must be fulfilled is that the definition of the M_PRODUCT_PRICE_WAREHOUSE_V must return exactly the same records with the same values as the view with the original definition.

In order to ensure that the new view definition is valid, both queries (the original and the new one) were executed against the same environment, and the results have been compared to ensure that they are identical. The result of this test can be found here.

Performance Tests

Every new improvement introduced has been measured along this project, so that it was possible to compare the changes in an incremental way.

All the performance tests are summarized in the following sheet.