Discussion Board for collaboration on QlikView Scripting.
I'm using AS400 as a datasources and currently I'm facing a bad performance when qlikview extract data from AS400, one table only.
This table have 65 of column and around 8million of records, the extraction will took around 6 - 8 hours.
1. Is the cause because of the number of columns?
2. or network? because AS400 is not in the same server.
3. The ODBC driver version? which version is the best?
4. How to optimized the extraction time?
Better schedule a data transfer from AS/400 to Qlikview server and then access the data locally. So do we.
what do you mean by data transfer from as/400, what is the type of that data?
The data type is .dif :
De: BayuAditya <email@example.com>
Para: carlosc <firstname.lastname@example.org>,
Fecha: 03/10/2012 05:30 p.m.
Asunto: - Re: Slow extraction on AS400
Re: Slow extraction on AS400
created by BayuAditya in Connectivity and Data Sources - View the full
what do you mean by data transfer from as/400, what is the type of that
Reply to this message by replying to this email -or- go to the message on
Start a new discussion in Connectivity and Data Sources by email or at
© 1993-2011 QlikTech International AB Copyright & Trademarks | Privacy