topic load problem from access database in QlikView https://community.qlik.com/t5/QlikView/load-problem-from-access-database/m-p/339930#M125456 <HTML><HEAD></HEAD><BODY><P>hi all </P><P></P><P>i&nbsp; have a access database with 42,000 rows.</P><P>i defines odbc connection (becuase it gave error to ODE LB conenction )</P><P>it doesnt give error when i run the script </P><P>it updatese 1800 rows than waits after that it reaches 4500 rows and waits normally </P><P></P><P>it must be faster.</P><P></P><P>where i do something wrong?</P><P>thnaks</P></BODY></HTML> Wed, 06 Jun 2012 13:18:42 GMT 2012-06-06T13:18:42Z load problem from access database https://community.qlik.com/t5/QlikView/load-problem-from-access-database/m-p/339930#M125456 <HTML><HEAD></HEAD><BODY><P>hi all </P><P></P><P>i&nbsp; have a access database with 42,000 rows.</P><P>i defines odbc connection (becuase it gave error to ODE LB conenction )</P><P>it doesnt give error when i run the script </P><P>it updatese 1800 rows than waits after that it reaches 4500 rows and waits normally </P><P></P><P>it must be faster.</P><P></P><P>where i do something wrong?</P><P>thnaks</P></BODY></HTML> Wed, 06 Jun 2012 13:18:42 GMT https://community.qlik.com/t5/QlikView/load-problem-from-access-database/m-p/339930#M125456 2012-06-06T13:18:42Z load problem from access database https://community.qlik.com/t5/QlikView/load-problem-from-access-database/m-p/339931#M125457 <HTML><HEAD></HEAD><BODY><P>i solved the problem. </P><P></P><P>if we do "select * from database " system will have low performance. so i selected only the fields that i need .</P></BODY></HTML> Mon, 11 Jun 2012 06:46:49 GMT https://community.qlik.com/t5/QlikView/load-problem-from-access-database/m-p/339931#M125457 2012-06-11T06:46:49Z