View source | View content page | Page history | Printable version   

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:

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.

Retrieved from "http://wiki.openbravo.com/wiki/Projects:DB_Support_Indexes_With_Functions/QA"

This page has been accessed 748 times. This page was last modified on 1 July 2015, at 15:01. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.