RE: $dbh->{RowCacheSize} = 1000

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

• $dbh->{RowCacheSize} = 1000 by Loo, Peter # PHX
• RE: $dbh->{RowCacheSize} = 1000 by Garrett, Philip
• RE: $dbh->{RowCacheSize} = 1000 by Garrett, Philip
• RE: $dbh->{RowCacheSize} = 1000 by Loo, Peter # PHX
• RE: $dbh->{RowCacheSize} = 1000 by Garrett, Philip
• RE: $dbh->{RowCacheSize} = 1000 by Loo, Peter # PHX
• RE: $dbh->{RowCacheSize} = 1000 by Ronald J Kimball