commit 2ff07c8befe399d2333932028aff9b711b949775
author Hector Oswaldo Caballero <hector.caballero@ericsson.com> Mon Jul 23 14:20:59 2018 +0000
committer Gerrit Code Review <noreply-gerritcodereview@google.com> Mon Jul 23 14:20:59 2018 +0000
tree 874347d3272421d0495357c13b9255a3ecbb10b7
parent 19bb9f90cdaaa741baf9b4f644036ddc99c969c4
parent 3bcb1492aa32cc5034d71f8c473f4a3ff9fa7e3b

Merge "Add indexes to speed up queries" into stable-2.14

WORKSPACE

diff --git a/WORKSPACE b/WORKSPACE
index 44dabc8..90f9649 100644
--- a/WORKSPACE
+++ b/WORKSPACE
@@ -3,7 +3,7 @@
 load("//:bazlets.bzl", "load_bazlets")
 
 load_bazlets(
-    commit = "11ce7521051ca73598d099aa8a396c9ffe932a74",
+    commit = "5e0b58a466804eca41dd99df75bdf8575de0d167",
     #    local_path = "/home/<user>/projects/bazlets",
 )
 

src/main/java/com/ericsson/gerrit/plugins/eventslog/sql/SQLQueryMaker.java

diff --git a/src/main/java/com/ericsson/gerrit/plugins/eventslog/sql/SQLQueryMaker.java b/src/main/java/com/ericsson/gerrit/plugins/eventslog/sql/SQLQueryMaker.java
index c84bfc9..09bba6d 100644
--- a/src/main/java/com/ericsson/gerrit/plugins/eventslog/sql/SQLQueryMaker.java
+++ b/src/main/java/com/ericsson/gerrit/plugins/eventslog/sql/SQLQueryMaker.java
@@ -59,7 +59,7 @@
       throw new MalformedQueryException(e);
     }
     return String.format(
-        "SELECT * FROM %s WHERE %s BETWEEN '%s' and '%s' LIMIT %d",
+        "SELECT * FROM %s WHERE %s BETWEEN '%s' and '%s' ORDER BY date_created LIMIT %d",
         TABLE_NAME, DATE_ENTRY, dates[0], dates[1], returnLimit);
   }