Details

    • Type: Feature Request
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 2.6.7 Final, 2.7.0 Final
    • Fix Version/s: 3.0 Final
    • Component/s: Portal Core
    • Labels:
      None

      Description

      See http://www.ludovicocaldara.net/dba/jboss-portal-and-mysql-scalability/

      Currently, following query is genrerated:

      SELECT PATH, NAME FROM JBP_OBJECT_NODE WHERE PK IN (
      SELECT NODE_KEY FROM JBP_OBJECT_NODE_SEC WHERE ROLE IN (
      SELECT jr.jbp_name FROM jbp_users ju, jbp_role_membership jrm,
      jbp_roles jr
      WHERE jrm.jbp_uid = ju.jbp_uid
      AND jr.jbp_rid = jrm.jbp_rid
      AND ju.jbp_uname = 'LUDOVICO'
      AND ju.jbp_enabled = 1));

      Should it be tuned to:

      SELECT DISTINCT a.PATH, a.NAME /* , b.NODE_KEY */ FROM JBP_OBJECT_NODE
      a, JBP_OBJECT_NODE_SEC b
      WHERE a.pk=b.NODE_KEY
      AND b.ROLE IN (
      SELECT jr.jbp_name FROM jbp_users ju, jbp_role_membership jrm,
      jbp_roles jr
      WHERE jrm.jbp_uid = ju.jbp_uid
      AND jr.jbp_rid = jrm.jbp_rid
      AND ju.jbp_uname = 'UTDEMO'
      AND ju.jbp_enabled = 1);

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  prabhat.jha Prabhat Jha
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: