load issue

[arulsettu]

hi

i am having 20 gb of data. when i load only three fields from a table it taking 1+ hour to load. is there any way to make it fast?

what is the issue?

[arulsettu]

its taking 1+ hour still loading data. is there any other way to load quickly. its loading based on my ram size?

[ashfaq_haseeb]

Hi,

You can look at performance by adding Index.

Regards

ASHFAQ

[rbecher]

I guess you have to speed up your database query (ask your db admin)  and your network connection..

- Ralf

[alexandros17]

Your Ram have great influence in your loading process.

[arulsettu]

using qlikview desktop with 2gb of ram

[rbecher]

No, not really. Either you have enough memory or not..

[arulsettu]

so ram is the issue. any other way?

[jagan]

Hi,

Are you using any conditions in Where? If yes, check whether there are indexes for those fields? 

Then try to limit the data, restrict some unwanted data, suppose if users are using only last years data, then load only last 3 years data instead of loading entire data.

If the issue still not fixed try to implement incremental loading refer Qlikview help file (F1) for this topic "QVD files and Incremental Load" and try to implement.

Hope below link helps you.

Incremental Load

Regards,

Jagan.

[arulsettu]

i just try to load three fields and stored into qvd. rows are 1534582.

only single table with three records.

[jagan]

Hi Arul,

If you try the same query in SQL Server or Oracle, how much time it is taking to get the results?

Regards,

Jagan.