Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a document with 12 million rows, 3 columns. Extracted from a optimized QVD.
I have two list boxes and one pivot with a count of id's in the document.
It takes about a minute to make one selection. I find this extremly slow.
Any ideas on how I can improve this.
Task Manager / Performance
Count of id's?
Try This
LOAD
Field1,
Field2,
Field3,
'1' as Counter
FROM YourSource;
And in the pivot table change the expression for Sum(Counter), the function sum takes less time to execute