dbWriteTable performance with MariaDB

General
, ,
#1

As recommended in
https://db.rstudio.com/databases/my-sql/
and in
https://cran.r-project.org/web/packages/RMySQL/index.html
i replaced the driver of my mysql connections to mariadb

bar<-config::get("foo",file = "../config.yml")

con2 <- dbConnect(
  drv = RMariaDB::MariaDB(), #new driver
  # drv = RMySQL::MySQL(), old driver
  username = bar$username,
  password = bar$pwd,
  host = bar$host,
  port = bar$port,
  dbname = bar$schema
)

as a consequence all my scripts with dbWriteTable() ran into poor performance or didn't finish at all
this very detailed github issue report boils down my current situation

do you have similar experiences with a switch to mariaDB driver?
are there some points i am missing (additional installations,..)?
are there any alternatives?

thanks for your understanding

#2

maybe this ?

#3

Writing in a .csv is absolute no option.
i am more puzzled why the newer recommended package is by far slower than the legacy package

#4

This topic was automatically closed after 45 days. New replies are no longer allowed.


If you have a query related to it or one of the replies, start a new topic and refer back with a link.