SqlInMessage & SqlOutMessage : how to get the ideal settings

forum.connectivity (2000-2005) & forum.td.connectivity (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 118939
Joined: 24 Feb 2017, 12:00
Location: World wide

SqlInMessage & SqlOutMessage : how to get the ideal settings

Post by NewsgroupServer » 12 Dec 2008, 07:08

 Posted by:  Dave Rabelink 

Having read all docs on the SqlInmessage and SqlOutMessage I was
playing around with some values.

Indeed, most SQL statements are performed much quicker now, when I
increase the settings.

I wonder though, why not set the settings to max ?
(to 32K=32768 bytes)

How can I determine which value would be best for particular
statements ? So, how do I determine the size of the resultsets ?

Does anyone have experience with this ?

I'm using DB2 connected through SqlHost using WinSocks (sqlws32.dll)

Regards,
Dave

Return to “td.connectivity”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests