[sr-dev] git:master:66718c2a: schema: add indexes to topos Mysql tables (#13)

[GitHub]

Module: kamailio
Branch: master
Commit: 66718c2a77ae4cc427d8a06b4fa308224a5b3d48
URL: https://github.com/kamailio/kamailio/commit/66718c2a77ae4cc427d8a06b4fa308224a5b3d48

Author: sergey-vb <sergey.v.basov at gmail.com>
Committer: GitHub <noreply at github.com>
Date: 2017-12-08T08:50:11+02:00

schema: add indexes to topos Mysql tables (#13)

* topos: update topos_d.xml

To optimize DB query speedup I propose to add few indexes.

*  topos: update topos_t.xml 

To optimize DB query speedup I propose to add few indexes.

---

Modified: src/lib/srdb1/schema/topos_d.xml
Modified: src/lib/srdb1/schema/topos_t.xml

---

Diff:  https://github.com/kamailio/kamailio/commit/66718c2a77ae4cc427d8a06b4fa308224a5b3d48.diff
Patch: https://github.com/kamailio/kamailio/commit/66718c2a77ae4cc427d8a06b4fa308224a5b3d48.patch

---

diff --git a/src/lib/srdb1/schema/topos_d.xml b/src/lib/srdb1/schema/topos_d.xml
index 85984faf9c..5b13333d62 100644
--- a/src/lib/srdb1/schema/topos_d.xml
+++ b/src/lib/srdb1/schema/topos_d.xml
@@ -225,4 +225,14 @@
         <colref linkend="a_callid"/>
     </index>
 
+    <index>
+        <name>a_uuid_idx</name>
+        <colref linkend="a_uuid"/>
+    </index>
+
+    <index>
+        <name>b_uuid_idx</name>
+        <colref linkend="b_uuid"/>
+    </index>
+
 </table>
diff --git a/src/lib/srdb1/schema/topos_t.xml b/src/lib/srdb1/schema/topos_t.xml
index 793fed4d1e..c6bc095aeb 100644
--- a/src/lib/srdb1/schema/topos_t.xml
+++ b/src/lib/srdb1/schema/topos_t.xml
@@ -232,4 +232,14 @@
         <colref linkend="a_callid"/>
     </index>
 
+    <index>
+        <name>x_vbranch_idx</name>
+        <colref linkend="x_vbranch"/>
+    </index>
+
+    <index>
+        <name>a_uuid_idx</name>
+        <colref linkend="a_uuid"/>
+    </index>
+
 </table>