[R] ROracle 0.5-0 package update

David James dj at research.bell-labs.com
Tue Apr 22 14:23:20 CEST 2003


An update to the ROracle package is now in CRAN.

Version 0.5-0

* This version has an experimental dynamic SQL binding to data
  frames.  SQL statements can be "prepared" (parsed and cached for
  improved performance), and columns of data frames bound to them
  for automatic data transfer).  For details see the help() for
  "Oracle", "dbPrepareStatement" and "dbExecStatement".

* Host arrays are now operational. These are buffers used by Oracle's
  internal implementation to reduce network traffic and speed
  up fetches and prepared statements.  Currently fetches use a
  default buffer size (host arrays) of size 500 (previous version
  did no buffering).  **Very preliminary** results suggest performance
  improvements on fetching of about a factor of 2.
  (Note that the maximum size of these buffers is limited to about 
  65K bytes per column.)
 
* dbCommit() and dbRollback() are now explicitly implemented,
  but save points are not (but you may code them through dynamic SQL).

* The precompiler ProC/C++ is now used with the option PARSE=none
  to avoid bogus C errors with some compilers and/or platforms
  (e.g., Mac OS X).

-- 
David A. James
Statistics Research, Room 2C-253            Phone:  (908) 582-3082       
Bell Labs, Lucent Technologies              Fax:    (908) 582-3340
Murray Hill, NJ 09794-0636



More information about the R-help mailing list