On 1 November 2012 11:47, Hasan Diwan <[email protected]> wrote:
> Sir,
>
> On 30 October 2012 04:32, aajit75 <[email protected]> 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]]
______________________________________________
[email protected] 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.
