Look at the docs for RowCacheSize. It often helps to set that
higher, at the expense of using more memory in the client. You
set it in the database handle; e.g.,
$dbh->{RowCacheSize} = 1000000;
[EMAIL PROTECTED] wrote:
> Hi,
>
> i'm doing some queries that dump a lot of records (1.000.000+).
>
> Are there any parameters I can set on the client to improve my performance?
>
> Any pointers?
>
> Thanks in advance.
>
>
--
Steve Sapovits
Global Sports Interactive
http://www.globalsports.com
Work Email: [EMAIL PROTECTED]
Home Email: [EMAIL PROTECTED]
Work Phone: 610-491-7087
Cell Phone: 610-574-7706
