topic Re: Regarding persistent class in Application Development and Automation Discussions

Regarding persistent class

Former Member — Thu, 17 Dec 2009 05:43:52 GMT

Hi All,

I have recently started working on persistent classes and need some quick inputs on the scope of persistent classes.

1. I have tried updating a custom table using create_persistent but this method creates one record at atime.......

Is it possible to do mass upload using persistent class. Assume if i have 10000 records in an internal table and i want to insert them in a custom table at one go.

In preocedural i can use insert and can update the table at one go insetad of inserting one by one .

Regards/Ajay Dhyani

Re: Regarding persistent class

matt — Thu, 17 Dec 2009 10:05:22 GMT

If you're dealing with many records, then the persistence framework is not appropriate. You should still encapsulate all your db operations away from the business logic, but use Open SQL rather than persistence.

matt

Re: Regarding persistent class

Former Member — Sat, 06 Mar 2010 16:35:06 GMT

Hey Ajay,

For mass uploads as you have said like 10000 records using persistence classes is not good,but if you want to upload these records in slots of couple of thousands i think using the methods of the persistence classes work fine. You have to loop the internal table and then call the persistence methods. Anyhow internally these methods also use Sql statements to upload the data into the database tables.

Regards,

Rahul Tripathi

Re: Regarding persistent class

matt — Sun, 07 Mar 2010 06:35:51 GMT

It is far more efficient to upload all the records using openSQL statements, via internal tables. Then the records are inserted into the table all in on go. Using persistence framework is like adding one record at a time. Most inefficient.

Re: Regarding persistent class

Former Member — Sun, 07 Mar 2010 08:15:34 GMT

Matt & Rahul,

i do agree with you......because of this limitation we in our scenario developed a normal Class in ABAP with sql statements wrapped ....just wondering if you can give a small real time scenario where these persistent classes can be utilized.

Regards/Ajay Dhyani

Re: Regarding persistent class

Former Member — Tue, 09 Mar 2010 11:44:44 GMT

This message was moderated.

Re: Regarding persistent class

Former Member — Wed, 10 Mar 2010 04:46:54 GMT

Persistence classes can be used to replace select statements,from your application logic. This can be the most important part of persistent classes and methods. You can use GET and SET methods to do so.

Regards,

Rahul.