Project

General

Profile

Revision 8335

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

View differences:

src/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
src/xmltables-postgres.sql
289 289
CREATE INDEX identifier_docid on identifier(docid);
290 290
CREATE INDEX identifier_rev on identifier(rev);
291 291
CREATE INDEX identifier_docid_rev on identifier(docid, rev);
292
CREATE INDEX identifier_docid_rev_log ON identifier((docid||'.'||rev));
292 293

  
293 294
/*
294 295
 * Table used to store all document identifiers for system metadata objects
......
401 402
  date_logged   TIMESTAMP,      -- the datetime on which the event occurred
402 403
  CONSTRAINT access_log_pk PRIMARY KEY (entryid)
403 404
);
405
CREATE INDEX access_log_docid ON access_log(docid);
404 406

  
407

  
405 408
/*
406 409
 * the index_event table for solr-based indexing
407 410
 */

Also available in: Unified diff