Re: [R] export from R to MySQL

From: Sean Davis <sdavis2_at_mail.nih.gov>
Date: Tue 13 Dec 2005 - 00:50:47 EST

On 12/12/05 8:33 AM, "Meinhard Ploner" <meinhardploner@gmx.net> wrote:

> Hi R user!
>
> What is the fastest way to export a large matrix or vector to a MySQL
> database? The use of data.frame() and dbWriteTable() makes the process
> slow, so is there any <direct> alternative?

Probably dumping to a text file and then using mysqlimport will be fastest, in terms of computation time, but you will have to create the table by hand (using SQL CREATE TABLE), so it might take just as much user time.

Sean



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Tue Dec 13 00:55:16 2005

This archive was generated by hypermail 2.1.8 : Tue 13 Dec 2005 - 02:28:22 EST