Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
briar
briar
  • Project overview
    • Project overview
    • Details
    • Activity
    • Releases
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 679
    • Issues 679
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
  • Merge Requests 12
    • Merge Requests 12
  • CI / CD
    • CI / CD
    • Pipelines
    • Jobs
    • Schedules
  • Operations
    • Operations
    • Incidents
    • Environments
  • Analytics
    • Analytics
    • CI / CD
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
  • briar
  • briarbriar
  • Issues
  • #1092

Closed
Open
Opened Oct 09, 2017 by akwizgran@akwizgranOwner
  • Report abuse
  • New issue
Report abuse New issue

Investigate performance of metadata queries

Investigate the performance of the following DB calls to see which indexes are being used, and whether adding new indexes would improve performance:

  • Database#getGroupMetadata(T, GroupId)
  • Database#getMessageMetadata(T, GroupId)
  • Database#getMessageMetadata(T, GroupId, Metadata)
  • Database#getMessageMetadata(T, MessageId)
  • Database#getMessageMetadataForValidator(T, MessageId)

http://www.h2database.com/html/performance.html#explain_plan

Assignee
Assign to
Android 1.0
Milestone
Android 1.0 (Past due)
Assign milestone
Time tracking
None
Due date
None
Reference: briar/briar#1092