I have large data tables in MySQL and is connected to R. I am using sqldf package in R to read tables from SQL and combining required tables to obtain the final table to carry out further analyses. But this is not very efficient as it occupies memory in R as well as it takes long time to extract big tables.

Is there a package or something in R that will help me work by directly referencing to tables in MySQL without having to read them first in R?

Thanks!

More Rajan Sharma's questions See All
Similar questions and discussions