Acceptable response time calling CWS?

big_shot

Good afternoon

I would like to know your opinion on this case ...

We have developed a customer demand web service that performs all these actions.

- Creation of a workspace from a template

- Creation of folder structure according to information received within the workspace

- Assignment of Security Clearance

- Information of approx. 600 total attributes

- 26 querys looking for documents

- Generation in the workspace of the folder structure and the generations of the documents found

As a result, the WS returns a list of found documents, along with their itemId and other small information.

The whole process works correctly and does what it needs to do, according to the requirements of the project ok ?, well ... here is the problem now ... The response time of the WS is 30 seconds after having made all these transactions , but we need a response time of 2 seconds maximum.

Is this possible ???, we have optimized everything that could be optimized ... code, queries, table indexes in DB.

How average time and to have a reference ... how long is the approximate time it takes to have an updated Business Workspace in a SAP integration for example ...

Thanks for your comments.

Cheers

Find more posts tagged with

Comments

Kashellkar_Vishal

You are performing many tasks in a single call and expect it to be completed in 2 seconds? I am not sure even if you write custom Oscript code to perform these tasks in a single call, it'll be able to complete everything in 2 seconds.

If you are concerned about leading application being unresponsive for the time the call gets completed, try using multithreading. This way your application wont be locked.

Appu Nair

The only way I know to say anything is and I will agree to @Vishal_Kashelkar as some design improvement can be done

Content Server has a priced utility called OT Performance analyzer, so what we all do is assuming the DB which is the most critical of everything in this run its connect logs ,then you would start looking at the analyzer .So one you try to do a discrete transaction like a container browse and then it that tool is a SQL analyzer which should tell you times. We check if browse is acceptable say 2 s or less.
Once the tool is understood then try the top most of your work cut and pasted from your question Creation of a workspace from a template. Did that transaction happen in an acceptable time?. Look for benchmarks of OT. For example I would fire up SOAPUI and create a Workspace call, or a REST API call and compare the two... or even go to the Add Item of a BWS and try that.

Now if this is custom development if you do that in the GUI does it compare to what custom did?

If you know some of these then the final user experience can be mitigated

In most of these exercises where I have participated in with OT Performance Experts, we have been able to find the root cause and mitigate it. It will take time. as the expert himself may not know the entire code line. So the logs are sent OT experts look over ,come back try again ,rinse and repeat .Since your is custom dev I would start gauging how smartui, classic ui and other's compare.

If it cannot be fixed sometimes customers will agree to a backgrounded design. What if you say the process will send a completion email...I don't know if 2s is something OT promises you would have to find something that gives you that confidence

tagging @David Templeton usually he will give good advise on your design hopefully he will respond...