Displaying 1 result from an estimated 1 matches for "tbl_simdata".
2004 May 25
0
RMySQL problem - SOLVED
Hi,
The problem was the row.names that were sent to the database and created
an primary key duplicate. Now it works fine.
BTW congratulations for the package. It copied 15300 rows by 11 columns
in less than 5 seconds, in my PIII 833 with 1 GB RAM.
> system.time(dbWriteTable(con, "TBL_SIMDATA", TBL.SIMDATA, append =
TRUE, row.names=F))
[1] 3.87 0.05 4.86 0.01 0.00
Just one suggestion. It would be usefull to have a more verbose output,
maybe the "LOAD DATA INFILE" output.
Thanks for your help.
EJ
On Tue, 2004-05-25 at 13:01, Sean Davis wrote:
> I have written ta...