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

Execution time in development server and quality server

koushikking
Explorer

‎2016 Apr 14 9:30 AM

0 Likes
669

Hi Experts,

I have 21000 records in custom table in development server and am doing some modifications on it, it is taking around 650 seconds to process all the records, but when we moved that tp to quality there we have around 300000 records, to process all these records it is taking more then 16hrs, as per calculations it should complete within 5 to 6 hours. so why it is elapsing too much time. Please anyone help me on this.

3 REPLIES 3
Read only

Former Member

‎2016 Apr 14 9:45 AM

0 Likes
641

Are you doing your modifications directly on the database table or an internal table? What are the fields of it (key fields, attributes fields; maybe you can post example field names)? Which fields do you modify and what's the condition for modifying them?

Are your DB statistics up to date?

Read only

koushikking
Explorer
In response to Former Member

‎2016 Apr 14 10:00 AM

0 Likes
641

thank for your reply,

am using internal tables for modifications and am using hash table concepts as well.

How to check DB statistics...

Read only

Former Member
In response to Former Member

‎2016 Apr 14 10:15 AM

0 Likes
641

You get an insight of the statistics through an analysing of the SQL-Trace via ST05.

Can you tell us your approach with the hash table by an example? The runtime sounds very strange if you are using internal tables with indexes.

Have you already checked your implementation with a trace by SAT (or SE30)? Where is your bottleneck (DB / ABAP Runtime)?