… and points beyond

One of the most useful tricks shared at the QlikView conference was from Nik Boman on improving the data extraction from databases.
ODBC is a slow protocol, running orders of magnitude slower than the database or a typical Ethernet connection. Very pricey ETL tools for data warehousing get around this by extracting through multiple connections to [...]

[Read more →]

QlikView is multi-threaded in many areas but not during the load process. Next time you’re running a load script, open the Windows Task Manager. If you have 2 cores, the processor usage will never go above 50%. You can to do this while QlikView is running and see what actions are single- and multi-threaded.
Load times [...]

[Read more →]