Investigate if database writing due to RMariaDB switch from RMySQL

[madison-feshuk]

Looks like others were seeing similar slowness from switching their database client package from RMySQL (not longer supported) to RMariaDB: r-dbi/RMariaDB#162 r-dbi/RMariaDB#265

There might be additional parameters we can configure on our end to better utilize RMariaDB and speed up processing, ex.

• Switch dbWriteTable with dbAppendTable
  

  CompTox-ToxCast-tcpl/R/tcplAppend.R

  Line 60 in c61f7d1

  dbWriteTable(conn = dbcon,

  
  OR
• In dbConnect, consider adding "load_data_local_infile = TRUE" as an additional parameter

[brown-jason]

you can currently use the load_data_local_infile with the tcplConf:
tcplConf(user=user, pass=pass, db='invitrodb_test', drvr='MySQL', host='ccte-mysql-res.dmap-prod.aws.epa.gov',load_data_local_infile = TRUE)

This is due to our addition of the dots ... to the tcplConf that allows anyone to pass additional parameters to dbconnect

[brown-jason]

load_data_local_infile appears to slow down write speeds.
benchmark.pdf