I don't have any recent production experience with SQLServer, but I
vaguely remember some Cayenne tests failing without
"selectMethod=cursor" years ago.
Andrus
On Nov 9, 2007, at 2:47 PM, Dan Morgan wrote:
Does anyone know if the new responseBuffering=adaptive connection
setting
has any performance improvements on large result sets with Cayenne?
Additionally does anyone know its interaction with the
selectMethod=cursor
option? Are they both necessary, conflicting, etc?
Lastly is selectMethod=cursor required for Cayenne to function
properly?
Thanks,
Daniel L. Morgan
EMail : <[EMAIL PROTECTED]>