Scalabilty

[#1]

Hi All,

I am using

Intel i5 2450 GHz

RAM 6 GB

HD 500 GB

QV 64bit Personal Edition

Ms Excel 32 bit

I loaded one excel file with 29 columns and one million rows with no program running except Qlikview. It takes 9-10 minutes. Is it OKK to take so much time in loading/relaoding!!!!???

Please advise.

Thanks in advance!

BR

SAK

[Anonymous]

Since you mention the Excel version I assume you're loading the data from Excel?

Speeds vary of course depending on the type of data source, connection quality and location. You could also look at incremental loading which should reduce your times drastically since I'm assuming you wouldn't load the whole dataset from source every time?

[#3]

Oh thanks Johannes.

It's really great if there is some option for incrmental loading. Surely most of the times no need to relaod whole data.

Can you please give some good links for reading about incremental loading?

Also please advise if I have daily sales report in one folder in separate excel files, how can I load only today's sales report incrementally. I mean I have already loaded all the files up to yesterday and then I have to load only today's sales report.

Thanks and best regards

SAK

[Anonymous]

Sure thing.

Here's a great example with sample scripts:

http://community.qlik.com/docs/DOC-1870