Displaying 1 result from an estimated 1 matches for "_less_time_".
2007 Apr 16
0
Reasons to Use R (no memory limitations :-))
...several million patients and want to analyze some specific subset - the following SQL statement
SELECT * FROM patients WHERE gender='M" AND AGE BETWEEN 30 AND 35
will result in bringing to R much smaller dataframe than selection of the whole table. [Also, such subset selection may take _less_time_ then selecting from the total dataframe - assuming the table is properly indexed].
Also, direct SQL statements can be used to pre-compute some characteristics internally in the database and bring only the summaries to R:
SELECT AVG(age) FROM patients GROUP BY gender
will bring a data frame of two...