Review main Abandoned

55941[TASK] Declare indexes for frequently dispatched queries

Claus Due CR 0 V 0 Easy +2 −1 updated 10/27/18, 16:22

Commit message

This patch adds two SQL table indexes:

* One for tt_content which matches the conditions used
  when selecting records by colPos (with e.g. RECORDS)
* Another for sys_file_reference which matches the query
  used to select a file reference with default constraints

Though a single page rendering doesn't use these queries
that frequently (extremely rarely exceeding 100 or so) the
added index does save a lot of the time spent on those
particular queries which are used on pretty much all pages.
The benefit is in the compound performance boost, not so
much the individual page load time.

Review

  • Code review CR 0

    Imported before Forger kept the single votes, the next import adds them.

  • Verified V 0

    Imported before Forger kept the single votes, the next import adds them.

Issues 1

Files 1