MicrosoftWe have a setup where we are experiencing slow throughput on larger SQL datasets returned from a query through a HCM setup. Have you done any comparisons or testing with large dataset returns?
In our case it does not seem to matter whether it is 10.000 rows of 1kb in size each or 1 row of 10Mb in size it seems to have the same slow through put. Locally the query is done in 1 sec. over HCM it takes 30-40 secs. We were expecting it to be slower than local of course, but 30-40 fold seems high.
Are there anything we can tweak in regards to the HCM setup that can make it faster?
