With databases, one issue that might be relevant is whether you want to > store data in tables (e.g. one table to store one data.frame) that can > subsequently be manipulated in the DB, or to store R objects as R > objects (e.g. as BLOBs). My situation is likely to be the later case, > and one of my concerns is that many DBs have an upper limit of 2GB on > BLOBs, and I might potentially have objects that are larger than this.
R objects in blobs - I never thought about that. Could you elaborate on how to do something like that (I am using RMySQL)? Thanks Rainer Finally, you might get more response on database issues from R-sig-db > than R-help. > > Best wishes > > Richard. > > > Thomas Pujol wrote: > > R-community, > > Sometime during the next 12-months, I plan on configuring a new computer > system on which I will primarily run "R" and a SQL database (Microsoft SQL > Server, MySQL, Oracle, etc). My primary goal is to "optimize" the system > for R, and for passing data to and from R and the database. > > > > I work with large datasets, and therefore I "think" one of my most > important goals should be to maximize the amount of RAM that R can utilize > effectively. > > > > I am seeking advice concerning the version of R, OS, processor, > hard-drive/storage configuration, database, etc. that I should consider. (I > am guessing that I should build a system with lots of RAM, and a Linux OS, > but am seeking advice from the R community.) If I choose Linux, does it > matter which version I use? Any opinion regarding implementing a > commercially supported version from a vendor such as Red Hat, Sun, etc? Is > any database particularly better at "exchanging" data with R? > > > > While cost is of course a consideration, it is probably a secondary > consideration to overall performance, reliability, and ease of ongoing > maintenance/support. > > > > Thanks! > > > > > > --------------------------------- > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > 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. > -- -- Rainer M. Krug, Dipl. Phys. (Germany), MSc Conservation Biology (UCT) Plant Conservation Unit Department of Botany University of Cape Town Rondebosch 7701 South Africa [[alternative HTML version deleted]] ______________________________________________ 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.
