Execute Large File Faster

[rajareddyjkl]

i have a 9GB qvw file.in that it contains a Straight table or Pivot table with 20 dimensions and 10 expressions.then reloading of the qvw file makes more  time..how can i execute fast.

[settu_periasamy]

I hope you already followed the some sample steps like below

If not, try it.

i) Filter the relevant data only into the  datamodel

- check the period of the data (date field)

ii) Do the binary load into the Layout

iii)do the limitations in the Charts(Straight / Pivot)

     - If the number of rows <=250000, then show the chart. Other wise, just show the message.

[rajareddyjkl]

Thanks for your reply, but how can we increase the speed by using binary load? Could you please explain?