[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.

[Bug 56705] AppDB tables need indexes

[WineHQ Bugzilla]

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

Ken Sharp  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |57151

[Bug 56705] AppDB tables need indexes

[WineHQ Bugzilla]

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

Jeremy Newman  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|NEW                         |RESOLVED

--- Comment #1 from Jeremy Newman  ---
Spent the time adding indexes to various tables. While these good be improved
even further, I think this should help speed things up a bit.

While I was in there, I cleaned up the DB setup scripts. I used a dump of the
current live database to create the new setup for the table structure.
Hopefully this makes it a tad easier for new PHP devs to come in and setup
their own working versions.

Git commit:
https://gitlab.winehq.org/winehq/appdb/-/commit/10c2339659b16a143eacaeb3299b...