Skip to content

briar
briar
Closed
Opened by akwizgran@akwizgran
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