Ticket #1729 (assigned enhancement)

Opened 2 years ago

Last modified 3 months ago

Need indices on sourcestamps.branch, sourcestamps.revision

Reported by: catlee Owned by: dustin
Priority: minor Milestone: 0.9.0
Version: 0.8.2 Keywords: database, sprint, simple
Cc:

Description

Without more indices on these tables, writing queries against this table is very painful.

Maybe want to index project and repository while we're at it.

Change History

comment:1 Changed 2 years ago by dustin

  • Milestone changed from 0.8.4 to 0.8.5

schema change -> 0.8.5

comment:2 Changed 6 months ago by tom.prince

  • Owner set to dustin
  • Status changed from new to assigned

comment:3 Changed 6 months ago by dustin

  • Milestone changed from 0.8.+ to 0.9.0

this will happen in nine.

comment:4 Changed 3 months ago by dustin

  • Keywords database, sprint, simple added; database removed

This will be a pretty simple improvement to nine.

Note: See TracTickets for help on using tickets.