On Dec 12, 2005, at 6:50 PM, David James wrote:
Prof Brian Ripley wrote:
On Mon, 12 Dec 2005, Sean Davis wrote:
On 12/12/05 9:21 AM, bogdan romocea [EMAIL PROTECTED] wrote:
Sean Davis wrote:
but you will have to create the table by hand
There's no need for manual steps. To take
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
__
R-help@stat.math.ethz.ch
On 12/12/05 8:33 AM, Meinhard Ploner [EMAIL PROTECTED] 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
from R to MySQL
On 12/12/05 8:33 AM, Meinhard Ploner [EMAIL PROTECTED] 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
On 12/12/05 9:21 AM, bogdan romocea [EMAIL PROTECTED] wrote:
Sean Davis wrote:
but you will have to create the table by hand
There's no need for manual steps. To take advantage of MySQL's
extremely fast 'load data infile' you could dump the data in CSV
format, write a script for mysql
That was just an example -- it's not difficult to write an R function
to generate the mysql create table syntax for a data frame with 60 or
600 columns. (BTW, I would never type 67 columns.)
On 12/12/05, Sean Davis [EMAIL PROTECTED] wrote:
On 12/12/05 9:21 AM, bogdan romocea [EMAIL
On Mon, 12 Dec 2005, Sean Davis wrote:
On 12/12/05 9:21 AM, bogdan romocea [EMAIL PROTECTED] wrote:
Sean Davis wrote:
but you will have to create the table by hand
There's no need for manual steps. To take advantage of MySQL's
extremely fast 'load data infile' you could dump the data in
Prof Brian Ripley wrote:
On Mon, 12 Dec 2005, Sean Davis wrote:
On 12/12/05 9:21 AM, bogdan romocea [EMAIL PROTECTED] wrote:
Sean Davis wrote:
but you will have to create the table by hand
There's no need for manual steps. To take advantage of MySQL's
extremely fast 'load