Re: Perl interface and BIG tables - Jochen Wiedmann - com.mysql.lists.perl

2 messages in com.mysql.lists.perlRe: Perl interface and BIG tables

From	Sent On	Attachments
Matija Grabnar	20 Oct 1999 00:25
Jochen Wiedmann	20 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