Loo, Peter # PHX wrote:
Hi,
Can someone please tell me what the size is when I set it to 1000? Is
it one meg?
It's $your_query_row_size * 1000. It's not a byte size, it's a number
of rows.
Regards,
Philip
Loo, Peter # PHX [mailto:[EMAIL PROTECTED] wrote:
Sent: Thursday, August 31, 2006 5:17 PM
To: DBI-Users
Subject: $dbh-{RowCacheSize} = 1000
Hi,
Can someone please tell me what the size is when I set it to 1000? Is
it one meg?
perldoc DBI:
RowCacheSize (integer)
A hint to
Hi All,
What would you recommend I set this option to if I am sending all the
SELECTed rows to a named pipe?
Peter
-Original Message-
From: Ronald J Kimball [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 31, 2006 2:23 PM
To: Loo, Peter # PHX; DBI-Users
Subject: RE: $dbh
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
31, 2006 2:44 PM
To: DBI-Users
Subject: 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