topic ODBC Connection is Slow in QlikView https://community.qlik.com/t5/QlikView/ODBC-Connection-is-Slow/m-p/1284611#M624711 <HTML><HEAD></HEAD><BODY><P>I am loading data via an ODBC Connection to a very large table containing 6 million records.&nbsp; The estimated time until completion of the load is 60 minutes. As an alternative I can export the data into a csv file and load the data from a MS Access Database, the wait time is only 1 minute.</P><P></P><P>I'm assuming the only efficient way to read this data in Qlikview is to first export to csv and then load from csv instead of loading from the ODBC connection, correct ?&nbsp; Is there a way to load data via an ODBC Connection so it takes only 1 minute ?</P></BODY></HTML> Mon, 21 Nov 2016 19:17:40 GMT 2016-11-21T19:17:40Z ODBC Connection is Slow https://community.qlik.com/t5/QlikView/ODBC-Connection-is-Slow/m-p/1284611#M624711 <HTML><HEAD></HEAD><BODY><P>I am loading data via an ODBC Connection to a very large table containing 6 million records.&nbsp; The estimated time until completion of the load is 60 minutes. As an alternative I can export the data into a csv file and load the data from a MS Access Database, the wait time is only 1 minute.</P><P></P><P>I'm assuming the only efficient way to read this data in Qlikview is to first export to csv and then load from csv instead of loading from the ODBC connection, correct ?&nbsp; Is there a way to load data via an ODBC Connection so it takes only 1 minute ?</P></BODY></HTML> Mon, 21 Nov 2016 19:17:40 GMT https://community.qlik.com/t5/QlikView/ODBC-Connection-is-Slow/m-p/1284611#M624711 2016-11-21T19:17:40Z