Hi all,
I need your opinion about using R-Rapache to build a knowlegde base to
bioinformatics field.
I have copious amount of genotype information (some few million records)
and would like to store it in MySQL database. Then, using RMySQL connector
I would like to use it for further analysis using R over a web interface.
The web interface which I am thnking off, just does not serve the purose of
statistical analysis, it should also serve as displaying data in grids and
interactive maps etc on web interface.
I had thought of doing the same using python-MySQLdb to store data and then
R-rpy for further statistical analysis. But as R is now directly made to
work on web I am very much excited about RApache project. Very recently I
was introducing Rapache project and concept of building knowledge base
using Rapache-R-MySQL combination to our team memebrs, Unfortunately few
memebers were not that happy with using R directly in middle tier. There
were serious comments about R that it is slow and generating plots on the
fly wont be too fast. there was also discussion about maturity of RMySQL
database connector, i mean fastness of querying MySQL will vary
significantly with RMySQL when campared to MySQLdb connector?
It would be nice if you give me a detailed opinion on this.
Thanking you all in anticipation.
Regards,
mlsc
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
