Projects:DB Support Indexes With Functions/QA
Automated Tests
The FunctionBasedIndexes class has been added to the ModelSuite in the DBSMTest project. That class contains the following tests:
- importBasicIndex: Checks that indexes not based on functions are imported properly
- exportBasicIndex: Checks that indexes not based on functions are exported properly
- importFunctionBasedIndexes: Checks that function based indexes are imported properly
- exportFunctionBasedIndexes: Checks that function based indexes are exported properly
- exportNonMonadicFunctionBasedIndex: Checks that function based indexes that use functions whose number of input parameters is not 1 are not exported
Each of these tests is executed several times, according to the following parameters: - Database type and version - Test Type: {onCreate, onDefault}. When the test type is onCreate, the indexes will be created in the create.database process, otherwise they will be created in the update.database process, after having loaded a base madel using create.database.
So far these tests have been run using PostgreSQL 9.1 and Oracle 11.2
Performance Tests
In an OB instance having 7 million business partners, creating a simple index on the value column took 134 seconds, and creating a function based index using upper took 142 seconds.
The increase in the insertion time after creating the function based index is negligible.