This would be a function of the database software more than R. For sqlite a few dozen gigabytes should be ok. Other databases can handle even larger requirements.
On Mon, Aug 25, 2008 at 9:17 AM, Ajay ohri <[EMAIL PROTECTED]> wrote: > R 's ability to work with large data sets is limited on PC. I am > trying it on cloud to overcome this but need help from other > programmers. > > Also tutorials would help to newbies > > regards, > > Ajay > > On Mon, Aug 25, 2008 at 6:42 PM, ivo welch <[EMAIL PROTECTED]> wrote: >> Dear R wizards: >> >> I decided to take the advice in the R data import/export manual and >> want to learn how to work with SQL for large data sets. I am trying >> SQLite with the DBI and RSQLite database interfaces. Speed is nice. >> Alas, I am struggling to find a tutorial that is geared for the kind >> of standard operations that I would want in R. Simple things: >> >> * how to determine the number of rows in a table. (Of course, I >> could select a row of data and then use this.) >> >> * how to insert a new column into my existing SQL table---say, the >> rank of another variable---and save it back. Am I supposed to create >> a new data frame, then save it as a new table, then delete the old SQL >> table? >> >> * how to save a revised version of my table in a different sort order >> (with or without deleting the original table). <-- I guess this is >> not appropriate, as I should think of SQL tables as unordered. >> >> I guess these would make nice little text snippets in the R Data >> import/export manual, too. help appreciated. >> >> regards, >> >> /ivo >> >> ______________________________________________ >> R-help@r-project.org mailing list >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html >> and provide commented, minimal, self-contained, reproducible code. >> > > > > -- > Regards, > > Ajay Ohri > http://tinyurl.com/liajayohri > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
