Learn R Programming

RMySQL (version 0.9-3)

safe.write: Write a data.frame avoiding exceeding memory limits

Description

This function batches calls to write.table to avoid exceeding memory limits for very large data.frames.

Usage

safe.write(value, file, batch, ...)

Arguments

value
a data.frame;
file
a file object (connection, file name, etc).
batch
maximum number of rows to write at a time.
...
any other arguments are passed to write.table.

Value

  • NULL, invisibly.

Details

The function has a while loop invoking write.table for subsets of batch rows of value. Since this is a helper function for mysqlWriteTable, it has hardcoded other arguments to write.table.

See Also

write.table

Examples

Run this code
ctr.file <- file("dump.sqloader", "w")
   safe.write(big.data, file = ctr.file, batch = 25000)

Run the code above in your browser using DataLab