topic Increase Package Size - SAP in QlikView

Increase Package Size - SAP

mike_garcia — Mon, 26 Jan 2026 21:26:37 GMT

Hello,

I'm pulling data via SAP Connector at a Rate of 5,000 record per second. I know there is a parameter to be placed in the connection String (Packetsize) to increase the number of records fetched per second. But when I set the parameter, apparently QV is ignoring it, since the packet size does not change.

If I set it to 20,000, it stays at 5,000. If I set it to 200, it is still 5,000. Am I doing something wrong regarding syntax?

This is how the string looks like:

CUSTOMCONNECT TO "Provider=QvSAPConnector;ASHOST=*************;SYSNR=**;CLIENT=***;XUserId=someuser;XPassword=somepassword;Packetsize=20000;";

Can someone help?

Also, when I load data from another set of tables, it goes down to 2,500 rows per second. What is causing it to drop?

Thanks in advance.

Increase Package Size - SAP

mike_garcia — Mon, 01 Mar 2010 20:00:48 GMT

Ideas please, anyone?

Increase Package Size - SAP

disqr_rm — Wed, 03 Mar 2010 04:44:10 GMT

Well, if you hange the connection parameters and nothing changes, I would recommend you contact the QlikTech support. Ideally the connection parameters should set the attributes in SAP to download the data.

Increase Package Size - SAP

Lars_Wahlstedt — Tue, 09 Mar 2010 14:05:01 GMT

Hi,

the packetsize parameter is an upper limit, to make sure the Connector doesn't use too much memory. At runtime the Connector calculates how much memory is avaliable and in many cases adjust the memory used downwards. In reality it does not affect the speed very much unless set too very low number.

Regards,

Lars Wahlstedt

Increase Package Size - SAP

suniljain — Mon, 12 Jul 2010 10:44:18 GMT

Dear Mike,

I have same types of problem . if change MaxRows Prperty it does not change accordingly.

Example :

ODSMaxRows=200000000;