topic Re: Execution time in development server and quality server in Application Development and Automation Discussions

Execution time in development server and quality server

koushikking — Thu, 14 Apr 2016 08:30:00 GMT

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.

Re: Execution time in development server and quality server

Former Member — Thu, 14 Apr 2016 08:45:13 GMT

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?

Re: Execution time in development server and quality server

koushikking — Thu, 14 Apr 2016 09:00:01 GMT

thank for your reply,

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

How to check DB statistics...

Re: Execution time in development server and quality server

Former Member — Thu, 14 Apr 2016 09:15:05 GMT

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)?