OPEN CURSOR vs Persistent class

Former Member — Wed, 04 Apr 2012 11:51:32 GMT

Hi Expert,

I want to update custom table containing more than 3 crore record. Please provide best development stratedgy to update so large record.

I am planning to use one of the following strategy

1. Open Cursor statement to break record in Smaller package size and update the record.

2 . Create a Persistent class for custome table, using trasactional service to break record based on certain condition and then using Persistent by query method on those set and update the record.

Which one is better stratedgy to update the record !

Is using Persistence class increase the performance on update task ?

Regards,

Kapil.

Re: OPEN CURSOR vs Persistent class

matt — Wed, 04 Apr 2012 12:15:21 GMT

Please note that "crore" is not well known in Europe and the US, so you are limiting your responses.

It is not recommended to use the persistence framework for mass processing of database records. Effectively you'd just be doing a load of select singles.

To read bulk data from the database, use OPEN CURSOR.

topic OPEN CURSOR vs Persistent class in Application Development and Automation Discussions

OPEN CURSOR vs Persistent class

Re: OPEN CURSOR vs Persistent class