title: Speed up sqlFetch()
body: <p>I am working with an Oracle database and like to fetch a table with 30 million records. </p>
  
  <pre><code>library(RODBC)
  ch &lt;- odbcConnect("test", uid="test_user", 
                    pwd="test_pwd", 
                    believeNRows=FALSE, readOnly=TRUE)
  db &lt;- sqlFetch(ch, "test_table")
  </code></pre>
  
  <p>For 1 million records the process needs 1074.58 sec. Thus, it takes quite a while for all 30 million records. Is there any possiblity to speed up the process? </p>
  
  <p>I would appreciate any help. Thanks.</p>