Updating 10 thousand records
1 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   Abhay_Shukla
Posted On:   Thursday, September 16, 2004 09:06 AM

I have a web based application which is used to update thousands of records in one transaction.
What approach should i take ?
Presently I am using batch statement to update. However,
While doing so (using DB2 as backend and WAS as server on different machines), I get out of memory error.

Report | Quote This | Send private message | Reply | Print

Re: Updating 10 thousand records

Posted By:   Christopher_Koenigsberg  
Posted On:   Sunday, September 26, 2004 05:42 AM

which server is getting the out of memory error? The WAS, presumably? maybe you could write a stored procedure in DB2, and submit parameters to it so it would do the bulk of the work, instead of WAS?
Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact