Skip to Content
avatar image
Former Member

Why is there so much sleep time in the threads and why are the threads not executing in parallel?

We have a calculation view which has one projection consuming one Column table with 184 fields. When we do the Plan Viz we can see that the result fetch or the analytical search at the last node takes the maximum time. What we observed was the threads spawned were not running in parallel even when there was no other job running in the system and inside the thread themselves there was a lot of sleep time, between the fetches. I am attaching a link to the doc with all the details. Please can someone just suggest why a simple fetch is taking so much time. The system details are also there in the document.Doc present in google drive

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 25 at 08:07 AM

    Any news regarding this issue. We are facing similar behavior.

    Add comment
    10|10000 characters needed characters exceeded