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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.