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.
anyone no how to change/Increase it, obviously the correct value is going to be trial and error but im ok with that ?
The default for FetchSize is 200
ColinR
CONNECT
TO [Provider=OraOLEDB.Oracle.1;FetchSize=100000,Persist Security Info=True;User ID=aapen;Data Source=live] (XPassword is UXBcBSVMSBbCGbYC);
