On 1 November 2012 11:47, Hasan Diwan wrote:
> Sir,
>
> On 30 October 2012 04:32, aajit75 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
Sir,
On 30 October 2012 04:32, aajit75 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/
Actually forget that loop, that was old code. Now remember i had to actually
split the one query down into several queries to get everything.
On 01.11.2012, at 18:38, Jessica Streicher wrote:
> I didn't have the same exception yet, but please make sure you have a stable
> connection (avoid wlan
I didn't have the same exception yet, but please make sure you have a stable
connection (avoid wlan).
I personally ran out of memory very often and had to make several queries,
combining the results in R instead.
This is probably not the best thing to do, but worked for me to fetch large
amount
4 matches
Mail list logo
