Improve performance of POST operations

[samatstariongroup]

Prerequisites

• [x] I have written a descriptive issue title
• [x] I have verified that I am running the latest version of the COMET Web Services
• [x] 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]

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