topic OLEDB FetchSize in QlikView https://community.qlik.com/t5/QlikView/OLEDB-FetchSize/m-p/164276#M37035 <HTML><HEAD></HEAD><BODY><P>my connection string is as follows but QV still returns a small number of rows per batch as it loading, indicating that there is a batch size configuration stored somewhere.</P><P>anyone no how to change/Increase it, obviously the correct value is going to be trial and error but im ok with that ?</P><P>The default for FetchSize is 200</P><P>ColinR<B></B></P><P style="font-weight: bold">CONNECT</P><B></B><P style="font-weight: bold"></P><B>TO</B> [Provider=OraOLEDB.Oracle.1;FetchSize=100000,Persist Security Info=True;User ID=aapen;Data Source=live] (XPassword is UXBcBSVMSBbCGbYC); <BR /><BR /> <P></P><P></P></BODY></HTML> Wed, 25 Nov 2009 01:49:14 GMT 2009-11-25T01:49:14Z OLEDB FetchSize https://community.qlik.com/t5/QlikView/OLEDB-FetchSize/m-p/164276#M37035 <HTML><HEAD></HEAD><BODY><P>my connection string is as follows but QV still returns a small number of rows per batch as it loading, indicating that there is a batch size configuration stored somewhere.</P><P>anyone no how to change/Increase it, obviously the correct value is going to be trial and error but im ok with that ?</P><P>The default for FetchSize is 200</P><P>ColinR<B></B></P><P style="font-weight: bold">CONNECT</P><B></B><P style="font-weight: bold"></P><B>TO</B> [Provider=OraOLEDB.Oracle.1;FetchSize=100000,Persist Security Info=True;User ID=aapen;Data Source=live] (XPassword is UXBcBSVMSBbCGbYC); <BR /><BR /> <P></P><P></P></BODY></HTML> Wed, 25 Nov 2009 01:49:14 GMT https://community.qlik.com/t5/QlikView/OLEDB-FetchSize/m-p/164276#M37035 2009-11-25T01:49:14Z