Uploaded image for project: 'JCommune'
  1. JCommune
  2. JC-1380

Optimize Mark All as Read for branch

VotersWatchers
    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.5 Larks, 2.12 Larks
    • Fix Version/s: 2.13 Larks
    • Labels:
      None
    • Sprint:
      2.13 Larks

      Description

      We can use the same approach which was added to all forum for branches. I recommend to add additional table(BRANCH_READ_TIME for example), in which we will store user and branch pair and the time of "mark all branch as read" action. It will decrease the number of record in LAST_READ_POST, so it will improve performance of our forum.

        Attachments

        1. after.png
          29 kB
          Mikhail Stryzhonak
        2. before.png
          29 kB
          Mikhail Stryzhonak

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. JC-2013 GenericJDBCException: could not execute query

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. JC-1685 Mark Branch as Read. Performance Improvements

          • Major - Major loss of function.
          • Closed

            Structure

              Activity

                People

                • Assignee:
                  ilyaa Ilya Ageev
                  Reporter:
                  ctapobep Stanislav Bashkyrtsev
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  8 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Structure Helper Panel