OPEN CURSOR vs Persistent class

[Former Member]

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.

[matt]

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.