fix: greatly improve performance of often-executed ping-fetch-query

[gigi.git] / src / org / cacert / gigi / database / upgrade / from_25.sql

diff --git a/src/org/cacert/gigi/database/upgrade/from_25.sql b/src/org/cacert/gigi/database/upgrade/from_25.sql
new file mode 100644 (file)
index 0000000..59e9218
--- /dev/null
+++ b/src/org/cacert/gigi/database/upgrade/from_25.sql
@@ -0,0 +1 @@
+CREATE INDEX ON "domainPinglog" ("configId","when");