Homec4science

BibIndex: consistency check optimizations

Authored by Jan Aage Lavik <jan.age.lavik@cern.ch> on Mar 27 2013, 14:09.

Description

BibIndex: consistency check optimizations

  • Amends the way we check for index table consistency during indexing of search index and ranking tables by amending slow queries and replacing them with more appropriate lightweight queries. (closes #1436)
  • Updates tabcreate.sql and BibIndex admin adding a key index on "type" column.
  • Creates a DB schema upgrade script for existing installations.

Co-authored-by: Alessio Deiana <alessio.deiana@cern.ch>
Reviewed-by: Samuele Kaplun <samuele.kaplun@cern.ch>

Event Timeline

Samuele Kaplun <samuele.kaplun@cern.ch> committed R3600:79c9cbc9ab48: BibIndex: consistency check optimizations (authored by Jan Aage Lavik <jan.age.lavik@cern.ch>).Dec 18 2013, 16:21