Application Development 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
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 

[Eclipse] SQL Console is too slow. Takes one core to 100%

NemanjaSimovic
Participant
0 Kudos

Dear Community,

Do anyone knows how to solve problem with SQL Console forcing one core to 100% of utilization? And on top of that it works so slow that even editor can't keep up with my very lousy typing skills. πŸ™‚

Here is the screenshot of SQL Console and CPU utilization while it's just sitting, and do nothing, but still making one core to sweat:

And here is the CPU utilization when I shutdown SQL Console:

I do use some dark theme, but I don't believe that could influence.

Btw, a link email of ADT team would be a good starting point. I have searched it several times, but it seams it's not easy to find it, at least for me. πŸ™‚

Regards,
Nemanja

  • SAP Managed Tags:
8 REPLIES 8

Sandra_Rossi
Active Contributor
0 Kudos

Maybe you could try first with harmless SQL code like SELECT * FROM T000 (instead of VBAP), it should return very few lines.

But you are saying than "even editor [is slow]". What do you mean? Is anything SAP working normally with your Eclipse installation?

To contact SAP, create a ticket at SAP Support with your S-User. https://support.sap.com.

  • SAP Managed Tags:

NemanjaSimovic
Participant

Hi sandra.rossi ,

Editor of SQL console is slow, because whole Eclipse application is slowed down. I believe it's because CPU usage is increased. When I switch to another tab, lets say another editor with class or another SAP GUI window, it starts behaving normally.

But what I did discover is if I write in select statement like this:

select * from vbap where vbeln = '1234567890'

Then it gets slowed down.

But if I name the fields in SELECT clause like this:

select vbeln, posnr, erdat from vbap where vbeln = '1234567890'

Then it behaves normal. Eclipse/SQL Console is not slowed down.

Still I have to test this couple of more times to be sure in my assertion. πŸ™‚

BR,
Nemanja

  • SAP Managed Tags:

bmayhs
Employee
Employee

Hi Nemanja,

Thanks for reporting this issue. We will need to dig deeper into this from our side. If we need additional support from you then I will get in touch with you.

-Shyam

  • SAP Managed Tags:

NemanjaSimovic
Participant
0 Kudos

Hi bmayhs ,

If you want to have pear to pear session, please contact me. Will be glad to help. πŸ™‚

Regards,
Nemanja

  • SAP Managed Tags:

Sandra_Rossi
Active Contributor
0 Kudos

Also, you could test if you indicate all VBAP columns explicitly, does it slow down too? (I guess it should be the same "speed" as with select *)

  • SAP Managed Tags:

NemanjaSimovic
Participant

Hi bmayhs ,

I have tested as sandra.rossi suggested with all 333 fields explicitly stated from VBAP (yes, we appended the table with ~70 columns), and result are the same. It blocks entire SQL Console. And one CPU core is at 100% all the time. Looks like "Data Preview" is the problem. Because server processing time is in milliseconds.

Hope this test helps.

BR
Nemanja

  • SAP Managed Tags:

NemanjaSimovic
Participant

Also one thing I forgot to mention, is that when I close "Data Preview" window CPU core utilization is back to normal. Everything points to "Data Preview" window.

Data Preview is mature for serious refactoring, anyway. πŸ™‚ Simple actions like copy cell or copy entire row are still challenging. πŸ™‚ bmayhs ask managers to give your team time for improvements. πŸ™‚

BR,
Nemanja

  • SAP Managed Tags:

bmayhs
Employee
Employee

Hi Nemanja,

Thanks for the information. We will look into issue and get back to you.

We are investing in changes for Data Preview & SQL Console. You will see some of them in the upcoming releases. Looking forward for your support and feedback once you get a chance to use them. Please lookout for the changes in the ADT Release Notes.

-Shyam

  • SAP Managed Tags: