Details

    • Type: Enhancement
    • Status: Open (View Workflow)
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Estimated Difficulty:
      Low

      Description

      When adding datasource for session storage Railo automatically creates cf_session_storage table in MySQL but without primary key. This can be a huge performance issue on big table.

      Manually add composite primary key (cfid,name) by executing a query:
      ALTER TABLE cf_session_data ADD PRIMARY KEY(cfid,name);

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                micstriit Michael Offner
                Reporter:
                scout Alex Beloglazov
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: