MySQL client ran out of memory

[Kamna Ramakrishnan]

Hi there,

Every time I attempt running my script it comes up with the above
mentioned error message. The script works perfectly fine on a pilot
dataset. My actual dataset is about 5000k.

If I just run the sql command from the mysql client with the --quick
parameter it does work.

Is there a way of using the quick parameter in DBI?

Cheers,
Kamna
--
**********************************
The University of Edinburgh
Molecular Medicine Centre
Western General Hospital
Crewe Road
Edinburgh
EH4 2XU

Tel: 0131 651 1008

The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.

[Peter J. Holzer]

On 2009-11-16 15:17:15 +0000, Kamna Ramakrishnan wrote:
> Every time I attempt running my script it comes up with the above
> mentioned error message. The script works perfectly fine on a pilot
> dataset. My actual dataset is about 5000k.
>
> If I just run the sql command from the mysql client with the --quick
> parameter it does work.
>
> Is there a way of using the quick parameter in DBI?

I think you may be looking for the database handle attribute
"mysql_use_result".

hp

--
_ | Peter J. Holzer | Auf jedem Computer sollte der Satz Ludwigs II
|_|_) | Sysadmin WSR | eingeprägt stehen: "Ein ewig Rätsel will ich
| | | h...@wsr.ac.at | bleiben, mir und andern."
__/ | http://www.hjp.at/ | -- Wolfram Heinrich in desd