Build: #135 was successful
Job: Default Job was successful
Code commits
Git
-
Rafal Korytkowski df90370adde14251bdef0538c8f3ddb8b0fd2544
Merge pull request #14 from suniala/MAP-5
MAP-5: Optimize metadata mapping queries by adding database indices -
Mikko Suniala <mikko.suniala@iki.fi> d7c3fab7c3360c3c3beac5e3d2c98155513e82d9
MAP-5: Optimize metadata mapping queries by adding database indices
Add indexes on those metadatamapping_metadata_term_mapping columns
that are used in queries and did not have indexes yet. Note that
some indexes already exist prior to this commit (namely the unique
indexes).
Also note that based on testing, mysql allows char values longer
than the 255 char limit (imposed by innodb) to be indexed.
Querying with a char value longer than 255 chars results in the
index as being used as a prefix index.- omod/src/main/resources/liquibase.xml (version d7c3fab7c3360c3c3beac5e3d2c98155513e82d9)