Projects:Table Recreation Prevention/QA
Functional
- Created ~200 jUnit test cases covering recreation and no recreation cases in AD and instance tables.
- Manually executed functional testes cases described in this sheet:
- Upgrade from 2.50 to current pi (3.0PR15Q2)
- Upgrade from 3.0MP17 to current pi (3.0PR15Q2)
- Install a module adding a new non mandatory column without default value to all core tables.
- Install a module adding a new a mandatory column with default value to all core tables.
Performance
Performance has been tested with different configurations and data sets, as described in this sheet. In all the cases measures refer to the time that complete update.database
takes.
- There was no case were the performance degraded.
- In some specific cases (adding new non mandatory columns without default value to all core tables in an instance with big amount of data) the improvement is significant, reducing from more than 11 hours to 3 minutes.