How to Handle big files ?

[#1]

Hello Everyone ,

I have a problem with handling a  big qvw file of the size more than 3 Gig. When i try to open it, it makes me wait like 15 to 20 mins . Does it make sense to make such big files for analysis? Is there any thing i can do to reduce the response time.? I have done optimizing also like working with qvd files used also binary loads and minimize the charts in the application... but still the size is big.I have 34  gig ram.

Share your experience guys...

Thanks,

Sal

[Jason_Michaelides · Accepted solution]

What's the spec of the server - that's an awfully long time to open up!?  Also, is your data model efficient - can you post a screenshot here?

Once it finally opens up, what's the performance like?

Jason

[#3]

thanks   Jason Michaelides for your reply,, yes you are right i think i should fix my data model ,..i should spend some time fixing it and try it again.

Regards,

Sal

[Jason_Michaelides]

No problem.  If you post a screenshot of the model we may be able to offer some advice.

[Sokkorn]

Hi Sal,

Read through this http://community.qlik.com/thread/18473 to get an idea on big data.

Here is my data:

Be care with your data model.

Regards,

Sokkorn

[Jason_Michaelides]

Sal,

If you have what you need please mark a correct answer so the thread appears closed to others.

Thanks,

Jason

[#7]

Hi Jason,

the problem was with my data model.Actually i made that application from the scrath again and its working fine.

Regards,

Sal