[Bug 56705] New: AppDB tables need indexes

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=56705

Bug ID: 56705
           Summary: AppDB tables need indexes
           Product: WineHQ Apps Database
           Version: unspecified
          Hardware: x86-64
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: appdb-unknown
          Assignee: [e-mail]
          Reporter: [e-mail]
      Distribution: ---

Many SQL tables used by the AppDB do not have indexes for fields used in WHERE
queries, and in sorts.

Generating those index now will take hours, and will take the DB offline (which
will affect Bugzilla as well). So this task will need to be scheduled over a
weekend.