Pivot table performance

[#1]

Dear all.

I have a big pivot table (aprox. 5.000 rows) which performance is fine on developer, but this performance turns bad when working in server environment. For example, once displayed the table, when the user tries to filter by a column value, the system hangs...

Nevertheless, we have a powerful server... Maybe QVS is not well tunned...

Any ideas? Which server parameters may improve this performance?

Thanks in advance and regards,

Julio.

[#2 · Accepted solution]

Issue solved once modified QVS performance parameters

[#3]

What performance parameters did you modify. I'm working with a huge pivot table (400k+) there are major issues.