Slow Document - 12 million rows

[Anonymous]

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.

[jolivares]

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.

[Mark_Little]

Hi,

Could be hard aware to? how much RAM do you have?

Also what is the data model like?

Mark

[syukyo_zhu]

Hi,

How much do you have distinct value in your 12 millons rows?

[Clever_Anjos]

Some questions:

• Only one table is beeing loaded?
• Is your RAM size enough?
• Are you using a plain field or an expression into your listbox?

[Anonymous]

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

• Only one table is beeing loaded? - Yes, with 3 columns.
• Is your RAM size enough? - How do I check this?
• Are you using a plain field or an expression into your listbox? Plain field in the list boxes (are 2).

[Anonymous]

I'm not sure exactly what you mean. There are 12 million distinct values, 3 columns.

[Anonymous]

How do I check the RAM? It is only one single table.

[Anonymous]

distinct value in your 12 millons rows? - 12 million distinct values, leadID's.

[Anonymous]

• Only one table is beeing loaded? - Yes, with 3 columns.
• Is your RAM size enough? - How do I check this?
• Are you using a plain field or an expression into your listbox? Plain field in the list boxes (are 2).