Project

General

Profile

Revision 8335

add 2 indexes to speed up dataONE log retrieval. https://projects.ecoinformatics.org/ecoinfo/issues/6161

View differences:

xmltables-oracle.sql
303 303
CREATE INDEX xml_access_idx4 ON xml_access (perm_order);
304 304
CREATE INDEX xml_access_idx5 ON xml_access (subtreeid);
305 305
CREATE INDEX xml_access_idx6 on xml_access(guid);
306
CREATE INDEX identifier_docid_rev_log ON identifier((docid||'.'||rev));
306 307

  
307 308

  
309

  
308 310
/*
309 311
 * Index of Nodes -- table to store precomputed paths through tree for
310 312
 * quick searching in structured searches
......
551 553
  date_logged   DATE,           -- the datetime on which the event occurred
552 554
  CONSTRAINT access_log_pk PRIMARY KEY (entryid)
553 555
);
556
CREATE INDEX access_log_docid ON access_log(docid);
554 557

  
555 558
CREATE SEQUENCE access_log_id_seq;
556 559
CREATE TRIGGER access_log_before_insert

Also available in: Unified diff