4 ms·
Yeah, data.table provides already significant speedup vs dplyr - so much that the "better" syntax of dplyr makes no sense anymore when you have to deal with ver
by ekianjo 8y ago
Yeah, data.table provides already significant speedup vs dplyr - so much that the "better" syntax of dplyr makes no sense anymore when you have to deal with very large datasets. But maybe FastR can somewhat change that?
- jsmith99 8y agoYou can use dplyr syntax on data tables, usually with data table speed, especially if you load dtplyr.
- tfehring 8y agoHow large are we talking? I haven't had any problems with dplyr performance as long as my data fits in main memory. (I have 16GB, so that means single digit GB data frames at most - I realize that doesn't qualify as "very large".) It does slow down considerably for larger data sets, but I assumed that that was because it was hitting the pagefile.
- minimaxir 8y agoI have had the same experience with dplyr. In the event that the data doesn't fit into memory, it's better to preprocess w/ SQL at the data-store level. There hasn't been a case where I'd need to feed massive amounts of data into a ggplot2 visualization unaggregated.
- baldfat 8y agoWait so the time difference of you running your code is longer then working with a "better syntax?" I spend hours cleaning up data and only have to run the code once (I normally save the output to a feather and then work with a separate file from there). I still believe that the 'tidyverse' is hands down the best thing that has happened to R and is the whole reason why R has grown so fast.
- WhompingWindows 8y agoSometimes it can take 12 or more hours to run the code on the millions of observations. There's also competition from other researchers who use computational resources, which can mean I have to leave something running for hours due to the server being heavily queried. My workflow also doesn't allow easy interruption of the execution, sometimes it has to execute fully incorrectly before I can change an error or parameter.
- semi-extrinsic 8y agoI dunno how large your data set is, but I just set up for work a 16-core Threadripper workstation with 32 GB RAM and 1 TB M.2 SSD for approx. $2500. If it can regularly save you hours or days of waiting, getting something equivalent should be a no-brainer.
- deleted 8y ago[deleted]
- baldfat 8y agoI would then say your using the wrong tool for your problem? I can't imagine 12 hour runs. I would imagine Spark is a better bet or is that not an option? https://spark.apache.org/docs/latest/sparkr.html https://spark.apache.org/docs/latest/sparkr.html
- steve_s 8y agoFastR doesn't alter the semantics of R, so when dplyr copies a vector in GNU-R then FastR has to copy it too. However, FastR does use reference counting (not sure if that's turned on in GNU-R 3.5.1 now) so it may avoid some unnecessary copies.