[sr-dev] git:master: lib/srdb1/schema: Updated indices for presence tables based on results of latest performance testing

[Peter Dunkley]

Module: sip-router
Branch: master
Commit: 2b62b73f8d966d2418c765839ab43b3dbc57545f
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=2b62b73f8d966d2418c765839ab43b3dbc57545f

Author: Peter Dunkley <peter.dunkley at crocodile-rcs.com>
Committer: Peter Dunkley <peter.dunkley at crocodile-rcs.com>
Date:   Tue Sep 11 13:59:55 2012 +0100

lib/srdb1/schema: Updated indices for presence tables based on results of latest performance testing

- By Hugh Waite @ Crocodile RCS Ltd and Peter Dunkley @ Crocodile RCS Ltd

---

 lib/srdb1/schema/pr_active_watchers.xml    |    5 ++++-
 lib/srdb1/schema/pr_pua.xml                |   27 +++------------------------
 lib/srdb1/schema/rls_presentity.xml        |    1 +
 lib/srdb1/schema/rls_watchers.xml          |    7 +------
 utils/kamctl/db_sqlite/presence-create.sql |   11 ++++-------
 utils/kamctl/db_sqlite/rls-create.sql      |    1 -
 utils/kamctl/mysql/presence-create.sql     |   11 ++++-------
 utils/kamctl/mysql/rls-create.sql          |    1 -
 utils/kamctl/oracle/presence-create.sql    |   11 ++++-------
 utils/kamctl/oracle/rls-create.sql         |    1 -
 utils/kamctl/postgres/presence-create.sql  |   11 ++++-------
 utils/kamctl/postgres/rls-create.sql       |    1 -
 12 files changed, 25 insertions(+), 63 deletions(-)

Diff:   http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=2b62b73f8d966d2418c765839ab43b3dbc57545f