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? Regards Meinhard Ploner
export from R to MySQL
2 messages · Meinhard Ploner, Sean Davis
On 12/12/05 8:33 AM, "Meinhard Ploner" <meinhardploner at 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