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.
How long is your register, i think you have another problem with your data. Actually I manipulate much more than this and is really quick.
Maybe Henric or someone from Qlik can help you check your data.
Hi,
Could be hard aware to? how much RAM do you have?
Also what is the data model like?
Mark
Hi,
How much do you have distinct value in your 12 millons rows?
Some questions:
Thank you everyone for your replies, below are my answers:
@Juan - How long is your register? I'm not sure exactly what you mean. There are 12 million distinct values, 3 columns.
@Mark - RAM? - How do I check this?
@Xia - distinct value in your 12 millons rows? - 12 million distinct values, leadID's.
@Clever
I'm not sure exactly what you mean. There are 12 million distinct values, 3 columns.
How do I check the RAM? It is only one single table.
distinct value in your 12 millons rows? - 12 million distinct values, leadID's.