Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Performance issue with condition records creation

Former Member

‎2008 May 06 6:12 PM

0 Likes
944

Hi,

I am using the FM RV_CONDITION_COPY, RV_CONDITION_SAVE and RV_CONDITION_RESET to create pricing condition records. I am seeing issues related to performance. It takes like 7 mins for creating 4000 records. We have looked at all possible performance tuning from COMMIT perspective and database perspective but the inserts are really taking a very long time. Can someone help me regarding this?

Thanks,

Anu

Hi,

I am using the FM RV_CONDITION_COPY, RV_CONDITION_SAVE and RV_CONDITION_RESET to create pricing condition records. I am seeing issues related to performance. It takes like 7 mins for creating 4000 records. We have looked at all possible performance tuning from COMMIT perspective and database perspective but the inserts are really taking a very long time. Can someone help me regarding this?

Thanks,

Anu

Reply
3 REPLIES 3
Read only

Former Member

‎2008 May 27 10:04 AM

0 Likes
689

hi

go to st05 and see the time taken by the insert stement

and again if it is slow then plz

refresh <table>

free <table >, statement to free the table from the buffer memory.

u can restrt the server if possible after that definitly the system will take less time.

thanks

rewards if useful

sachhidananda

Read only

Former Member

‎2008 May 27 10:15 AM

0 Likes
689

Hi,

I'm not sure about your functionality of the code. There are so many processes in the FMs you have mentioned, some you may not require.

Now you run your program through [SE30|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/7769] [original link is broken] [original link is broken] [original link is broken]; and [ST05|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/7205] [original link is broken] [original link is broken] [original link is broken];. With these details you can concentrate on the areas where you can improve the performance.

One suggestion is that, if you have lots of internal tables involved, then free them wherever necessary as it might consume memory!!!

regards,

madhu

Read only

Former Member

‎2013 Dec 26 6:35 AM

0 Likes
689

Hi,

How did you solve the performance issue?

I'm also having the same problem.

Thanks,

Dave