Re: setFetchSize() [Viruschecked]

oh, so pgsql is the problem, not the driver?
  If I understand what you said well, I just have to turn off autocommit and set fetchsize to any positive number and
thedriver will do its work, right? 

On Thu, 17 Jul 2003 19:11:44 +0200
"Patric Bechtel" <bechtel@ipcon.de> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Thu, 17 Jul 2003 13:01:43 -0400, Dmitry Tkach wrote:
>
> Hello Dmitry,
>
> that's exactly what the driver is doing if you do a setFetchSize(10).
> Nevertheless, it won't solve the problem of the server eating HUGE amounts of memory if you do a "declare foo cursor
forselect * from myhugetable". It seems  
> like postgresql locks all rows (or even copies them around in memory) until the connection drops again.
>
> Patric
>
> >Rich Cullingford wrote:
>
> >> All,
> >> Will this function be implemented in Release 7.4? I have several arge
> >> tables that run Java out of memory when I attempt to load them through
> >> JDBC. Any workarounds arppreciated...
>
> >I was using cursors for a while as a workaround...
> >Something like this:
>
> >c.setAutocommit (false);
> >Statement s = c.createStatement ();
> >s.execute ("declare foo cursor for select * from bar");
>
> >while (true)
> >{
> >    ResultSet rs = s.executeQuery ("fetch 10 from foo");
> >    int count = 0;
> >    while (rs.next ())
> >    {
> >        count++;
> >        doStuffWithThisRow (rs);
> >     }
> >
> >     if (count < 10) //The whole cursor contents has been processed
> >          break;
> >}
> >
> >
> >I hope, it helps...
>
> >Dima
>
>
>
> >---------------------------(end of broadcast)---------------------------
> >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
>
> PGP Public Key Fingerprint: 2636 F26E F523 7D62  4377 D206 7C68 06BB
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPsdk version 1.7.1 (C) 1997-1999 Network Associates, Inc. and its affiliated companies.
>
> iQA/AwUBPxbKwXxoBrvMu8qQEQKC8gCfWN0mM5HfiheSggCracN3JPglHckAn0KI
> G5m+Vo0NZQ9l53pE44U9EpyK
> =udRs
> -----END PGP SIGNATURE-----
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend


--

 /~\ The ASCII        Felipe Schnack (felipes@ritterdosreis.br)
 \ / Ribbon Campaign  Analista de Sistemas
  X  Against HTML     Cel.: 51-91287530
 / \ Email!           Linux Counter #281893

Centro Universitário Ritter dos Reis
http://www.ritterdosreis.br
ritter@ritterdosreis.br
Fone: 51-32303341