diff options
| author |   Jim Hahn <jrh3@att.com> | 2020-05-21 17:53:14 -0400 |
|---|---|---|
| committer | Jim Hahn <jrh3@att.com> | 2020-05-21 17:54:23 -0400 |
| commit | 7587e14625ff5bf93dae1fb4f014c96b6e13b3e3 (patch) | |
| tree | 8b9bce65ed5b35cc0749bfc623c78123b733ac04 | |
| parent | b583c352509402607ed82eb09ffc9d6b7ed0515a (diff) | |
Add secondary indices to operationshistory table
Queries to the operationshistory table will degrade substantially
as more records are added to the DB.
The Dbao class should be moved to policy-models, but for now
we'll just update it in both places (i.e., drools-apps and xacml-pdp).
Issue-ID: POLICY-2581
Signed-off-by: Jim Hahn <jrh3@att.com>
Change-Id: Icc4529e56968ceda4d9b63a8ccea6ba219250506
Signed-off-by: Jim Hahn <jrh3@att.com>
| -rw-r--r-- | applications/common/src/main/java/org/onap/policy/pdp/xacml/application/common/operationshistory/Dbao.java | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/applications/common/src/main/java/org/onap/policy/pdp/xacml/application/common/operationshistory/Dbao.java b/applications/common/src/main/java/org/onap/policy/pdp/xacml/application/common/operationshistory/Dbao.java index 2b70c9be..b4ee5594 100644 --- a/applications/common/src/main/java/org/onap/policy/pdp/xacml/application/common/operationshistory/Dbao.java +++ b/applications/common/src/main/java/org/onap/policy/pdp/xacml/application/common/operationshistory/Dbao.java @@ -2,7 +2,7 @@ * ============LICENSE_START======================================================= * ONAP * ================================================================================ - * Copyright (C) 2019 AT&T Intellectual Property. All rights reserved. + * Copyright (C) 2019-2020 AT&T Intellectual Property. All rights reserved. * ================================================================================ * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. @@ -24,17 +24,18 @@ package org.onap.policy.pdp.xacml.application.common.operationshistory; import java.io.Serializable; import java.util.Date; - import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.Id; +import javax.persistence.Index; import javax.persistence.Table; - import lombok.Data; @Entity -@Table(name = "operationshistory") +@Table(name = "operationshistory", + indexes = {@Index(name = "operationshistory_clreqid_index", columnList = "closedLoopName,requestId"), + @Index(name = "operationshistory_target_index", columnList = "target,operation,actor")}) @Data public class Dbao implements Serializable { |