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:
- build .r script files run specific functions [using php].
- export data mysql csv files [using php]
- run exec () commands in php run r commands via command prompt a. read data csv b. perform r operations c. write output output files
- 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
Post a Comment