topic Re: Executing OpenSQL statement takes too long in SQL Console in Eclipse in Application Development and Automation Discussions

Executing OpenSQL statement takes too long in SQL Console in Eclipse

NemanjaSimovic — Tue, 29 Mar 2022 01:10:14 GMT

Hi all,

Why is there a large discrepancy in time between server processing time of OpenSQL query and result retrieval, in SQL Console?

Very often I see that "server processing time" is couple of milliseconds, but I see results only after couple of minutes (five to ten).

Even if I deliberately make a syntax error I get the error message after 5 minutes. Crazy! 🙂

Is there a way to track where the bottleneck is? SM66 doesn't give me much.

Regards
Nemanja

Shyam_Balachandran — Wed, 13 Jul 2022 05:40:41 GMT

Hi Nemanja,

Let me look into this and get back to you.

-Shyam

Sandra_Rossi — Wed, 13 Jul 2022 06:00:20 GMT

No issue at my side (ADT 2109 / ABAP 7.52):

SELECT 
   VBAK~MANDT, 
   VBAK~VBELN, 
   VBAK~ERDAT,
   VBAP~MATNR 
 FROM 
  VBAK 
 INNER JOIN VBAP 
    ON VBAK~VBELN = VBAP~VBELN

NemanjaSimovic — Fri, 15 Aug 2025 10:57:53 GMT

It's working fine for some time. 👌 Send regards to ADT team! 👋👋👋