Module: kamailio Branch: master Commit: 66718c2a77ae4cc427d8a06b4fa308224a5b3d48 URL: https://github.com/kamailio/kamailio/commit/66718c2a77ae4cc427d8a06b4fa30822...
Author: sergey-vb sergey.v.basov@gmail.com Committer: GitHub noreply@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/66718c2a77ae4cc427d8a06b4fa30822... Patch: https://github.com/kamailio/kamailio/commit/66718c2a77ae4cc427d8a06b4fa30822...
---
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>