slow insert with RMySQL

75 Views Asked by At

I have been using the package RMySQL

drv <- dbDriver("MySQL")
mydb <-  dbConnect(drv=drv,
                   user=*****,
                   password=******,
                   dbname=******,
                   host=*********, port = 3306)

I am doing insert to a raspberry PI

I am getting writing speeds very slow speeds, 10 seconds for 10000 records, possible reasons for that slow speed? My reading speeds are quite good.

Any suggestion on what to check?

Sincerely

Thank you very much

0

There are 0 best solutions below