https://bugs.winehq.org/show_bug.cgi?id=56706
Bug ID: 56706 Summary: AppDB does not properly separate the Bugzilla DB Product: WineHQ Apps Database Version: unspecified Hardware: x86-64 OS: Linux Status: NEW Severity: normal Priority: P2 Component: appdb-unknown Assignee: wine-bugs@winehq.org Reporter: jnewman@codeweavers.com Distribution: ---
We would like to split the AppDB and Bugzilla databases onto different hosts. But right now this is impossible due to some queries doing a joins between bugzilla and the appdb.
These will need to be re-written to do it in a different way.
The worst offender is testData.php ShowVersionsTestingTable method on line 685.
I'm sure there are other places as well.
https://bugs.winehq.org/show_bug.cgi?id=56706
Jeremy Newman jnewman@codeweavers.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Severity|normal |major
--- Comment #1 from Jeremy Newman jnewman@codeweavers.com --- Bumping this up in priority.
If I could split the databases for appdb and bugs into different servers then that will surely help the performance of both sites.
https://bugs.winehq.org/show_bug.cgi?id=56706
Ken Sharp imwellcushtymelike@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Blocks| |57151
http://bugs.winehq.org/show_bug.cgi?id=56706
wineryyyyy@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |wineryyyyy@gmail.com
--- Comment #2 from wineryyyyy@gmail.com --- (In reply to Jeremy Newman from comment #1)
Bumping this up in priority.
If I could split the databases for appdb and bugs into different servers then that will surely help the performance of both sites.
In case this is still has bumped priority, please see:
https://gitlab.winehq.org/winehq/appdb/-/merge_requests/13