Improve SQL request in charge to set snapshots.isLast column to 0

Details

  • Type: Improvement Improvement
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: None
  • Fix Version/s: 1.12
  • Component/s: Tuning
  • Labels:
    None

Description

The following SQL request is doing a full scan on snapshots.path column

update snapshots set islast=?, status=? where root_snapshot_id=? or id=? or path like ?

Activity

Hide
Permalink
Simon Brandhof added a comment -

This request is done when analysis of the root project ends. It sets the ISLAST flag.
See org.sonar.batch.core.FinalizeSnapshotsJob.

Show
Simon Brandhof added a comment - This request is done when analysis of the root project ends. It sets the ISLAST flag. See org.sonar.batch.core.FinalizeSnapshotsJob.

People

  • Assignee:
    Simon Brandhof
    Reporter:
    Freddy Mallet
Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: