mysql - using R in PHP and not having to reload R packages -


i have existing system data in mysql , program logic in php. use r support statistical requirements.

a brief background on legacy system needs improvement is:

  1. build .r script files run specific functions [using php].
  2. export data mysql csv files [using php]
  3. run exec () commands in php run r commands via command prompt a. read data csv b. perform r operations c. write output output files
  4. read output output files [in php]

the above mentioned system has obvious problems need with:
1) poor performance due 'unclean' data exchange via mysql php csv files r. --> solution, think, using rmysql package.

2) running multiple r commands via php exec() command requires r libraries reload every time command run. performance drain.

i appreciate suggestions on how improve system or advice on solving problem 2) or advice on alternative ways integrate mysql, php , r effectively.

thanks!


Comments