Thanks Jim.
"Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message
news:XGvL9.180386$pN3.13387_at_sccrnsc03...
> Comments embedded
> "chauhan" <parvez.chauhan_at_am-beo.com> wrote in message
> news:3dfe277e$0$239$ed9e5944_at_reading.news.pipex.net...
> > Hi all,
> > At the moment in our server ( written in java) we cache all records of a
> > query from database (Oracle8i) and we manipulate them as per client
> > requirement.
> >
> > Now we have a problem i.e. records have grown too high( millions ) and
> > sometimes query results in retrieval of millions of records. It results
in
> > too much memory consumtion in our server.
> > What is the best way to address this issue?
> > If we use oracle cursor .. can I move back and forwrd in cursor and also
> all
> > records will be cached in oracle memory area and I think it will still
> > result in memory consumtion as both servers (our server and oracle) are
on
> > same machine.
> >
> You can move back and forth if the driver allows it. Some drivers do,
some
> don't. Using a cursor on the server does not allocate all the result in
> memory on the server. It only retrieves rows as you fetch them. So a
> result set of millions of records will not take up any more space in ram
> (due to using a cursor) than a result set of 100 records.
> Jim
> > Any help will be highly appreciated.
> >
> > Thanks & regards,
> > Parvez
> >
> >
>
>
Received on Tue Dec 17 2002 - 07:32:00 CST
