Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Improve performance of POST operations #232

Open
3 of 6 tasks
samatstariongroup opened this issue Sep 23, 2021 · 1 comment
Open
3 of 6 tasks

Improve performance of POST operations #232

samatstariongroup opened this issue Sep 23, 2021 · 1 comment
Assignees
@samatstariongroup
Labels
1sp major a major issue performance webservices
Projects
COMET-CE

Comments

@samatstariongroup
Copy link
Member

Prerequisites

  • I have written a descriptive issue title
  • I have verified that I am running the latest version of the COMET Web Services
  • I have searched open and closed issues to ensure it has not already been reported

Description

When a POST message is being processed the service is performing a number of reads on the database. Many of these reads seem to be on the defined VIEWs (which are expensive queries) which should be done on the CACHE tables.

Steps to Reproduce

NA

System Configuration

  • COMET Web Services version:
    • CDP4Common:
    • PostrgreSQL:
    • Other:
  • Environment (Operating system, version and so on):
  • .NET Framework version:
  • Mono version:
  • Additional information:
@samatstariongroup samatstariongroup self-assigned this Sep 23, 2021
@samatstariongroup samatstariongroup added this to Under Review in COMET-CE Sep 23, 2021
@samatstariongroup
Copy link
Member Author

@stepjah we are working on making larger operations more performing. This includes creating copies of ElementDefinitions that contain sets of Parameters

@samatstariongroup samatstariongroup linked a pull request Sep 23, 2021 that will close this issue
[Improve] performance of the OperationProcessor by allowing it to read from the Cahce tables instead of VIEWs where appropriate #233
Closed
4 tasks
samatstariongroup added a commit that referenced this issue Sep 24, 2021
@samatstariongroup
[Improve] performance of the OperationProcessor by allowing it to rea…
6443981 
…d from the Cahce tables instead of VIEWs where appropriate; fixes #232
@lxatstariongroup lxatstariongroup added this to the sprint 41 milestone Sep 24, 2021
samatstariongroup added a commit that referenced this issue Sep 27, 2021
@samatstariongroup
[Improve] performance of the OperationProcessor by allowing it to rea…
cea710c 
…d from the Cahce tables instead of VIEWs where appropriate; fixes #232
@lxatstariongroup lxatstariongroup moved this from Under Review to In Progress in COMET-CE Oct 6, 2021
@lxatstariongroup lxatstariongroup moved this from In Progress to Sprint Backlog in COMET-CE Dec 6, 2021
@lxatstariongroup lxatstariongroup removed this from the sprint 41 milestone Mar 15, 2022
samatstariongroup added a commit that referenced this issue Mar 23, 2022
@samatstariongroup
[Improve] performance of the OperationProcessor by allowing it to rea…
5344135 
…d from the Cahce tables instead of VIEWs where appropriate; fixes #232
@samatstariongroup samatstariongroup moved this from Sprint Backlog to Backlog in COMET-CE May 1, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@samatstariongroup samatstariongroup

Labels
1sp major a major issue performance webservices
Projects
COMET-CE
Status: Backlog
COMET-CE
  
Backlog
Milestone
No milestone
2 participants
@samatstariongroup @lxatstariongroup