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

Author: Peter Dunkley peter.dunkley@crocodile-rcs.com Committer: Peter Dunkley peter.dunkley@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=2b62...