[R] odbcQuery , memory.size

From: Lukas Rohrer <lukas.rohrer_at_env.ethz.ch>
Date: Tue, 18 Mar 2008 09:46:08 +0100

Dear R cracks

I am trying to fetch 38 Tables from 38 ESRI Geodatabases through an ODBC connection.

I stored the 38 channels in a list and the 38 tablenames in an other list. With a

for(i in 1:38) .... sqlFetch(....) I try to read the tables into a third list. But always after a certain amount of rounds (mostly 16) i get

Fehler in odbcQuery(channel, query, rows_at_time) :

        Calloc konnte nicht (67108864 von 1) Speicher zuteilen Zusätzlich: Warning message:
Reached total allocation of 1021Mb: see help(memory.size)

When I keep on trying the rounds will stop at 1.

Any sugestions?

Sincerely Lukas


Tel: +41 44 632 55 98

ETH Zürich
Institut für terrestrische Ökosysteme
Professur Waldökologie
Universitätstrasse 22

CH-8092 Zürich

        [[alternative HTML version deleted]]

R-help_at_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. Received on Tue 18 Mar 2008 - 08:53:09 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 18 Mar 2008 - 09:30:22 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive