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

Module: kamailio Branch: master Commit: 66718c2a77ae4cc427d8a06b4fa308224a5b3d48 URL: https://github.com/kamailio/kamailio/commit/66718c2a77ae4cc427d8a06b4fa3082… Author: sergey-vb &lt;sergey.v.basov(a)gmail.com&gt; Committer: GitHub &lt;noreply(a)github.com&gt; 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/66718c2a77ae4cc427d8a06b4fa3082… Patch: https://github.com/kamailio/kamailio/commit/66718c2a77ae4cc427d8a06b4fa3082… --- 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>