Teradata and QlikView

[saumyashah90]

As we know when QlikView hits a database it takes each and every row one by one.
Is there any way to take huge data from database(Teradata) to qlikview fast or performance could be better.

There is thousand's of MB's of data being pulled from the data base

[kaushiknsolanki]

Hi,

     Use the logic of the Incremental load. This will help you only a set of the data from huge table which is newly updated or inserted.

Regards,

Kaushik Solanki

[#3]

Refer to this :

http://community.qlik.com/message/377629

I know its a very long thread, but very useful. You will find tips & tricks to enhance performance in between.

Also, you can find many other discussions on community.

[#4]

Incremental loads can help with with the reload performance if you need to have all the data in memory (and your hardware/infrastructure can handle it).

Direct Discovery (QlikView v11.2) or document chaining are worth considering when you need to limit the amount of data being loaded into memory.

[saumyashah90]

yeah i am aware about the incremental approach.

but wanted to know if  Direct Discovery could help me out

[#6]

The current version of Direct Discovery has a few limitations but it may be the solution to your issue.

An overview can be found here: http://www.qlik.com/us/~/media/Files/resource-library/global-us/direct/datasheets/DS-QlikView-Direct...

I believe there are some demos on YouTube too.

Direct Discovery v2 will be released in the near future as part of QlikView v11.2 SR5:

http://community.qlik.com/blogs/technicalbulletin/2013/11/07/qlikview-1120-service-release-5-pre-bet...