Loo, Peter # PHX wrote: > > "RowCacheSize" (integer) > > What would you recommend I set this option to if I am sending all the > SELECTed rows to a named pipe?
I'd recommend you leave it alone, unless your database roundtrips are really expensive. And if they are, the only thing that can tell you what the best value would be is to benchmark different settings. It will only help if the program on the other end of the named pipe can accept data faster than you can send it. Philip