Build: #135 was successful Changes by Rafal Korytkowski and Mikko Suniala <mikko.suniala@iki.fi>

Code commits

Git

  • Rafal Korytkowski

    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>

    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)