Message-ID: <BFC2EA67.1527%sdavis2@mail.nih.gov>
Date: 2005-12-12T13:50:47Z
From: Sean Davis
Subject: export from R to MySQL
In-Reply-To: <46eaa973f1e904b7856498d6ce62afb8@gmx.net>
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