Uploaded image for project: 'Document Management System'
  1. Document Management System
  2. DMS-1688

CBATS : Performance for Status Summary API

    Details

    • Type: Maintenance
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Labels:
      None

      Description

      Currently API Scan all documents and all routing / status to get latest status. Which is very time consuming.
      To make it fast we can add new column into document table which will contain latest status and Updated Date.

      Once document status set to Completed & Rejected after that if user viewed document then no need to update status as Viewed.

      So we can get latest status of document of document and no need to join with document routing.

        Attachments

          Activity

          Hide
          akash.thakur Akash Thakur (Inactive) added a comment -

          Hi All,

          We are done with code changes for this JIRA several changes were made to enhance the performance of API using our approach. we have unit tested all impact areas and have created PR for the same. Harshveer Singh please review the changes

          Thanks,

          Akash Thakur

           

          Rohan J Khandave Samir Harshveer Singh Ganesh Sadawarte 

           

          Show
          akash.thakur Akash Thakur (Inactive) added a comment - Hi All, We are done with code changes for this JIRA several changes were made to enhance the performance of API using our approach. we have unit tested all impact areas and have created PR for the same. Harshveer Singh please review the changes Thanks, Akash Thakur   Rohan J Khandave Samir Harshveer Singh Ganesh Sadawarte    
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Environment: Preprod - OneIM
          API:
          1. Latest Status
          2. Status Summary and
          3. Status History

          Verified for count only as there are hardly 25 templates available, so performance is good.

          Count is matching. So, marking jira done.

          Samir Hrishikesh Deshpande Rohan J Khandave Akash Thakur Hrishikesh Deshpande

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: Preprod - OneIM API: 1. Latest Status 2. Status Summary and 3. Status History Verified for count only as there are hardly 25 templates available, so performance is good. Count is matching. So, marking jira done. Samir Hrishikesh Deshpande Rohan J Khandave Akash Thakur Hrishikesh Deshpande

            People

            Assignee:
            priya.dhamande Priya Dhamande (Inactive)
            Reporter:
            rohan.khandave Rohan J Khandave (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 28h
                28h
                Remaining:
                Time Spent - 26.2h Remaining Estimate - 1.8h
                1.8h
                Logged:
                Time Spent - 26.2h Remaining Estimate - 1.8h
                26.2h