In an upcoming project I will work with a large amount of data stored on a SQL server. As best practive it can be read everywhere that for performance reasons the arithmetic operations are best done in the database itself, i.e. "push operation - collect results". With the dplyr package this can be easily achieved with tbl(con, "test"). Can I also achieve this approach with the DBI package (which I have not worked with yet)?
I would work with the dyplr package, but when the table in my database exceeds a certain size I unfortunately get an error.