Page MenuHomePhabricator
Create Task
Maniphest T212435

Review real-world query plans and performance for Jade
Closed, DeclinedPublic
Actions

Description

The JOINs between Jade tables and MediaWiki recentchanges should be reviewed as we accumulate real data in the tables. There's some potential for bad optimization and full scans, and certain filter conditions will be very sparse.

Do this task once we hit something like 1M rows.

Related Objects
Search...

StatusSubtypeAssignedTask
 DeclinedNoneT212435 Review real-world query plans and performance for Jade
 DeclinedcalbonT183381 Deploy pilot of Jade to a small set of wikis.
 InvalidNoneT183276 Design curation/suppression integration with MediaWiki (for JADE)
 InvalidNoneT183204 Build consumable dumps of JADE
 ResolvedawightT188307 Extension review for JADE
 ResolvedawightT190690 Design review for JADE
 ResolvedawightT194219 Implement multi-judgment and endorsement schema for Extension:JADE
 ResolvedawightT196547 [Epic] Extension:JADE scalability concerns
 ResolvedHalfakT200297 Review Jade data storage and architecture proposal [RFC]
 ResolvedNoneT200365 Explore alternative names for Jade data
 InvalidNoneT208552 Fix translations of "judgment" concept
 ResolvedHalfakT212178 [Epic] Align terminology and user experience in Jade code with Jade pitch
 ResolvedawightT202596 Write our anticipated "phase two" schemas and submit for review
 ResolvedHarejT197668 Write a letter to JADE stakeholders
 DuplicateNoneT199069 [Epic] Write user-facing documentation for Jade
 DeclinedNoneT199520 Determine which wikis will get Jade and when
 ResolvedawightT203030 Use local articlequality assessment scale for JADE.
 ResolvedawightT203037 Avoid polymorphic database columns in the JADE schema
 DeclinedNoneT201361 Jade Implementation: Watchlist integration
 ResolvedReedyT211046 Rename "JADE" extension to "Jade"
 ResolvedLadsgroupT212181 Rename JADE->Jade in continuous integration
 ResolvedLadsgroupT212182 Rename JADE->Jade in beta cluster configuration
 Resolved• mmodellT212180 Clone gerrit repo mediawiki/extensions/JADE to mediawiki/extensions/Jade
 ResolvedNoneT221053 Move code from "JADE" repository to "Jade" repository
 ResolvedNoneT221054 Update all references to "JADE" in codebase and messages to "Jade"
 ResolvedhasharT221436 GitHub should point to "Jade" and not "JADE"
 ResolvedNoneT221437 Archive "JADE" extension repository
 ResolvedawightT211346 Make Jade UI elements translatable
 DeclinedNoneT212373 Complete Jade user testing
 DuplicateNoneT210535 [EPIC] Jade Mockups: Prepare mockups of Jade initial feature set for user testing
 DeclinedNoneT210560 Jade Mockups: Watchlist integration
 DeclinedNoneT212378 Jade Wireframes: Watchlist integration
 DeclinedNoneT210562 Create test fixtures for Jade user testing
 DuplicateNoneT212385 Jade Implementation: Entry edit mode
 DuplicateNoneT199128 Jade Mockups: Entry edit mode
 DuplicateHarejT168993 Prepare a UI mockup for the JADE editor interface
 InvalidNoneT153157 JADE: Link from scored edit to this tool feedback interface
 DuplicateHalfakT212374 Jade Wireframes: Entity edit mode
 DuplicateNoneT212388 Jade Implementation: Search integration
 InvalidNoneT212372 Jade Mockups: Search integration
 InvalidNoneT212380 Jade Wireframes: Search integration
 Resolved• ACrazeT229967 Complete Jade documentation
 Resolved• ACrazeT229968 Write Jade extension documentation
 Resolved• ACrazeT235280 Write data consumer documentation for Jade
 Resolved• ACrazeT199834 Implement a MW API module for interacting with Jade entities
 DeclinedNoneT201651 Implement fluent API for Jade entity JSON
 Duplicate• ACrazeT217904 Write API contract for Jade
 ResolvedHalfakT229362 Describe "catchall" endpoint for Jade
ResolvedHalfakT229969 Describe Jade use-cases
 Resolved• ACrazeT242007 Write Jade API documentation
 Resolved• ACrazeT255219 Docker install docs for Jade
 ResolvedNoneT199519 Write user-facing documentation for Jade
 ResolvedHalfakT204905 Write glossary of JADE concepts
 Resolved• ACrazeT253230 Write UI walk-through for Jade user-facing documentation
 Resolved• ACrazeT242008 Write Jade documentation for secondary integrations
 ResolvedkevinbaziraT253232 Add a link to [[mw:Jade]] within the information dialog/tooltip for a facet
 Resolved• ACrazeT244152 Jade local dev setup / README docs
 Resolved• ACrazeT229973 Implement Jade Entity pages
 Resolved• ACrazeT208819 Implement Jade Entity UI
 ResolvedNoneT207415 Make JADE "preferred" consensus clear; borrow from !vote styling
 ResolvedHalfakT212370 Design Jade entity UI
 DuplicateHalfakT212379 Jade Wireframes: Entity view mode
 ResolvedkevinbaziraT242648 Implement CSS styles for Jade Entity UI
 Resolved• ACrazeT245316 Implement Diff view for Jade Entity UI
 Resolved• ACrazeT245311 Address Jade UI issues.
Resolved• ACrazeT229355 Simplify and extend JADE content schema (based on API spec insights)
 ResolvedHalfakT247762 Design diff *of* Jade entity pages
 Resolved• ACrazeT250725 [Spike] How can we render custom diffs for Jade pages?
 Resolved• ACrazeT229974 Implement secondary Jade Integrations
 ResolvedkevinbaziraT229975 Implement New Filters integration (RecentChanges/Watchlist)
 ResolvedHalfakT229976 Design New Filters controls for Jade
 Resolved• ACrazeT229977 Implement secondary schemas for joining Jade data to other tables
 Resolved• ACrazeT235003 Clean up naming conflicts around writing secondary schema data for Jade
 DeclinedNoneT206352 Implement search indexing for Jade entity pages
 ResolvedkevinbaziraT212387 Implement Special:Diff integration for Jade
 ResolvedHalfakT210558 Design Special:Diff integration for Jade
 DuplicateHalfakT212377 Jade Wireframes: Diff view controls
 ResolvedkevinbaziraT253751 Add [ edit | talk ] links to facet header in 2ndary integrations for Jade
 ResolvedkevinbaziraT253752 [Spike] Explore use of AJAX pattern for secondary Jade integrations

Event Timeline

awight created this task.Dec 20 2018, 5:52 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 20 2018, 5:52 PM
awight added a subtask: T183381: Deploy pilot of Jade to a small set of wikis..Dec 20 2018, 5:53 PM
• Marostegui triaged this task as Medium priority.Dec 20 2018, 6:19 PM
• Marostegui moved this task from Triage to Blocked external/Not db team on the DBA board.
awight updated the task description. (Show Details)Dec 20 2018, 7:25 PM
Halfak lowered the priority of this task from Medium to Low.Feb 19 2019, 10:43 PM
Halfak moved this task from Unsorted to Research & analysis on the Machine-Learning-Team board.
awight unsubscribed.Mar 21 2019, 4:05 PM
Halfak edited projects, added Machine-Learning-Team (Research); removed Machine-Learning-Team.Apr 2 2019, 9:33 PM
calbon closed subtask T183381: Deploy pilot of Jade to a small set of wikis. as Resolved.Sep 23 2020, 4:18 PM
calbon moved this task from Research to Ready to go on the Machine-Learning-Team board.Sep 23 2020, 4:42 PM
calbon edited projects, added Machine-Learning-Team; removed Machine-Learning-Team (Research).
• ACraze moved this task to Jade on the Machine-Learning-Team board.Jan 19 2021, 8:37 PM
LSobanski removed a project: DBA.Apr 6 2021, 2:27 PM
LSobanski subscribed.

Removing the DBA tag and subscribing myself instead. If there are any specific actions for DBA please re-add us or @mention me.

Ladsgroup changed the status of subtask T183381: Deploy pilot of Jade to a small set of wikis. from Resolved to Declined.Apr 28 2021, 9:49 PM
Aklapper lowered the priority of this task from Low to Lowest.May 23 2021, 10:54 PM
• ACraze closed this task as Declined.Jul 13 2021, 9:15 PM
• ACraze subscribed.

Jade is archived, see: T281430: Archive Jade extension

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL