Log in to AnswerLog in to Follow
2021-09-21 09-26-31
A S
51Views
1Comments
Aggregates and Advanced SQL performing very slow
Question
Aggregate
Performance
Reactive
SQL

Hi Team, 

I am currently working on the enterprise environment.

Data manipulation takes too much time to process with the minimum record (10000). I am not sure why the performance issue is happening. In aggregate, preparing data without filter, it is taking 60 seconds and with the filter applied, data preparation takes 70+ seconds. same behavior in advanced SQL also.

Note that the Service Studio itself hangs during development when we work on Advanced SQL or Aggregate widgets.

  • Development method: Reactive
  • No external DB integrated

Can someone help me to find the cause of the issue?

Thanks, Aadhavan S

0
1
19 Nov 2021
2020-09-15 13-07-23
Kilian Hekhuis
mvp_badge
MVP

Hi Aadhavan,

This sounds like either a networking problem (which you should take up with your organisation's IT department) or something that OutSystems Support should take a look at, but not something that anyone on the forum would be able to answer. I would advise you to log a case with OutSystems Support, and let them help you.

0
0
19 Nov 2021
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.