Settings for Packet Size

[StevenLunn]

Hi,

From Cognos, when accessing a particular data source (Microsoft SQL     
Server OLE DB) and running reports where large volumes of rows are     
returned, many of our Cognos reports are slow.                         
                                                                       
If we take the Cognos SQL and run it against the data source directly   
the results come back a lot faster, usually within a couple of minutes.
                                                                       
This suggests that it is the transfer of data from the data source to   
Cognos, rather than the execution of SQL that is causing the           
bottleneck. Experimenting directly with the data source some more and   
again transferring the returned data to another system (but not Cognos)
the slowness was still there. However this was improved dramatically by
increasing the packet size to the largest allowed (32767 from default   
4096).                                                                 
                                                                       
So we were wondering if there was a packet size setting in Cognos that 
we could amend to increase the transfer size between the data source   
and Cognos which would improve the reports? It's been suggested that we
could try adding Packet Size=32767; to the end of the connection string
on the Cognos data source, but it appears we cant change this in any   
way - Edit Connection string settings don't show anywhere to modify     
this.                                                                   
                         
If anyone has any ideas would appreciate it.

Thanks,

Steve