Excuse me, if the following is FAQ or nonsense, I'm new to R (and the
list)!
After trying to import a textfile of 184897 Bytes, R (v0.63.0 on Linux
2.0.35/DLD 5.4) gives the following error message:
> read.table ("db.out")
Error: heap memory (1953 Kb) exhausted [needed 150 Kb more]
>
Is there a possibility to increase heap size to import larger files?
Files up to 100 k are imported correctly. The file contains a single
column with a floating point value on each row.
Second question: Is it possible to construct an extension that
facilitates the import of data from databases, e.g. postgresql? (or
does it already exist?)
I have something like
> DataF <- read.fromDB ("select aaa, bbb from data", dbURL)
in mind, given that dbURL is the URL of a database accessible over
jdbc, odbc and alike, for example? (a separate connect-to-db-function
to handle database access/connect is more realistic, of course). There
would have to be an interface which connects to the db, executes the
query by passing the sql statement ("select ..."), and finally
delivers the output to R (or gives an error message, if necessary).
Many thanks for your attention,
Ulf
--
===================================================================== %%%%%
Ulf Mehlig <umehlig at zmt.uni-bremen.de>
%%%%!%%% Projekt "MADAM" <umehlig at
uni-bremen.de>
%%%% %!% %%%% ----------------------------------------------------
---| %%% MADAM: MAngrove | Center for Tropical Marine
||--%!% Dynamics | Biology
|| And | Fahrenheitstrasse 1
_ /||\_/\_ Management |
/ / \ \ ~~~~~~~~~~~~~~~~~ | 28359 Bremen/Germany
~~~~~~~~~~~~~~~~~~~~
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
