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 Mon Dec 16 2002 - 20:08:56 CST
