Forum Discussion

JVos's avatar
JVos
Icon for Helper IV rankHelper IV
7 years ago
Solved

Performance problem at Table.RowCount

The query below has a performance problem at the last step: #"Counted Rows". I inserted this step to replace some others steps that gave performance problems, so I inserted the count because I had th...
Need Help
  • JVos's avatar
    JVos
    7 years ago

    I turned out to be a performance issue with one of the queries that are invoked. So this issue is closed.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Does the query perform fine without that Row count last step?

JVos's avatar
JVos
Icon for Helper IV rankHelper IV
7 years ago

When I open the Excel file and then open the query in the Query Editor, and start clicking on the first step, then second step, and so on, then first 1 or 2 minutes the system seems to be very busy so those first steps. After that I can click the steps subsequently and the results per step are displayed. I also can go back to one of the first steps and the results are quickly displayed.

 

However when I after that choose on the Excel sheet to refresh that data, it again takes a long while (5 to 10 minutes). Mashup Evaluation Container is taking about 25% of my processor capacity.

 

So it's maybe not the last step that is the problem. I also can't detect (a) certain other step(s) that are the problem.

 

The workbook has many other queries which are performing OK. 'Fast Data Load' is on, 'Enable background refresh' is off.