Hi,
I am loading data from mysql intop my web application. But it's taking a bit higher time. Is there any other method to load data faster in the application.
con= dbConnect(drv = RMySQL::MySQL(), dbname = "database",
host = "100.0.0.1", port=3306,
user = "ank123", password = "123456789")
master<-dbReadTable(dbGetQuery(con, sql("select column 1, column 2, column 3....column 8 from table_name")))
I tired- data.table, data.frame , they are taking near about equal time.