Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
simospa
Partner
Partner

Loading 45 milion rows...

Hi all,

one of my customers is trying to load data from a Oracle table with a simple script:

SELECT field1, field2, ..., field 15 from tableName;

Loading all rows required 23 minutes, and before loading he had to wait for 12 minutes to have che "close" button avaible.

RAM: 12 Gb, QV 11, local client.

Any ideas of what he can do? Is the pc's RAM not enough?

Thanks,

S.

3 Replies
tresesco
MVP
MVP

Not only RAM, your local system's configuration too could be a factor of improvement consideration . Try loading same in a server and see the difference yourself.

To understand the RAM calculation, refer: Re: Calculate how much RAM needed?

Not applicable

Hi, If it is a regular task, then consider Incremental Loading for subsequent loading.

-Ram

simospa
Partner
Partner
Author

It's already on a server, although there is a local client version on.

S.