Connected to this RMySQL performs much better (using GROUP BY and functions such as GROUP_CONCAT which allows you to order and use a separator too).
So, I would recommend using them if you want grouping with sorting. On May 6, 2:36 pm, Steve Harman <[email protected]> wrote: > Hello ! > When grouping using data.table, mean and sum functions applied within > groups work well but if we use sort(x) function it takes much longer. > > I would like to do first sort(x) and put it inside paste such as > paste(sort(x),collapse=",") > I was wondering if there is any more efficient of effective way of > doing this? > > thanks in advance, > > Steve > _______________________________________________ > datatable-help mailing list > [email protected]https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatabl... _______________________________________________ datatable-help mailing list [email protected] https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help
