[GRASSLIST:3484] Re: R and GRASS

[Markus Neteler]

On Mon, May 24, 2004 at 11:54:13AM -0400, Claudia Codeco wrote:
> Hi I can't install RODBC for use with GRASS/R , It keeps complaining
> that it can't find the ODBC driver manager. 
> 
> My system is 
> 
> Linux Mandrake 9.2
> R 1.9
> UnixODBC 2.2.8
> postgresql 7.3.4

Since you work on a Linux platform, let me recommend the Rdbi interface
instead of RODBC. It's much faster:

 http://grass.itc.it/statsgrass/r_and_dbms.html
 Reading a table with 7512 obs. (rows) of  151 variables (columns):
  RODBC: 270 seconds
  Rdbi:    5 seconds

  Ratio:
  > 5/270
  [1] 0.01851852


Best

 Markus