On 1 November 2012 11:47, Hasan Diwan <hasan.diwan@gmail.com> wrote:

> Sir,
>
> On 30 October 2012 04:32, aajit75 <aajit75@yahoo.co.in> wrote:
>>
>> Please suggest where  am i going wrong or alternate option to solve such
>> issues  while reading large DB table.
>>
>
> You might consider setting the fetch size. I haven't used RJDBC in a few
> months, but hopefully, the hints on
> http://www.rforge.net/doc/packages/RJDBC/html/JDBCResult-methods.html point
> you in the right direction? If not, email me off-list and I'll try to come
> up with some sample code to help you. -- H
>

Indeed... the magic incantation seems to be:
results <- dbSendQuery(connection, sqlStatement)
partial.result.set <- fetch(results, number.to.fetch.in.one.go)
partial.result.set should be a data.frame with the number you've asked for.
It may take some tweaking to get it correct, but this is how to set the
fetch size in RJDBC. -- H


-- 
Sent from my mobile device
Envoyait de mon portable

	[[alternative HTML version deleted]]


