Ticket #248 (closed concern: fixed)

Opened 19 months ago

Last modified 3 months ago

sohocat -- indexing

Reported by: joe Owned by: jacob
Priority: normal Milestone:
Component: DP:SDAC Version: 1.2
Severity: normal Keywords:
Cc:

Description

before running all of the deletes, index observation.id_instrume

check the index SQL files

Change History

comment:1 Changed 3 months ago by jacob

  • Owner changed from joe to jacob
  • Status changed from new to accepted

comment:2 Changed 3 months ago by jacob

  • Status changed from accepted to closed
  • Resolution set to fixed

Moved the statement that indexes id_instrume before deletes in observation.sql. Ran an update and it works fine. This was probably just a performance improvement for the soho updating script.

Note: See TracTickets for help on using tickets.