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

Module: sip-router Branch: master Commit: 2b62b73f8d966d2418c765839ab43b3dbc57545f URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=2b62b73… Author: Peter Dunkley <peter.dunkley(a)crocodile-rcs.com> Committer: Peter Dunkley <peter.dunkley(a)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=2b6…