2 messages in com.mysql.lists.perlRe: Perl interface and BIG tables
FromSent OnAttachments
Matija Grabnar20 Oct 1999 00:25 
Jochen Wiedmann20 Oct 1999 01:35 
Subject:Re: Perl interface and BIG tables
From:Jochen Wiedmann (joch@gmx.de)
Date:10/20/1999 01:35:33 AM
List:com.mysql.lists.perl

Is there any way to force the perl DBI interface to fetch from mysql record by record, rather than building a table in memory?

Yes, use the "mysql_use_result" option, see "perldoc DBD::mysql" for details. Note that you should not use this options for concurrent operations, as it tends to block the server. However, for your application it seems quite right.

Bye,

Jochen