Skip to main content
Solved

Tips for creating a GI that does not slow down the entire system.


Forum|alt.badge.img+1

Hello,

A client recently created a GI and the system almost came to a standstill.  When the process was stopped the performance was back to normal.

I seem to think that there was a post about things to avoid when designing a GI so that it does not drain too much of the CPU but cant find it.

 

Can anyone help?

 

Thanks

James

 

Best answer by Laura02

Hello,

Look at what tables are being used and how they are joined. Incorrect joins can cause many multiples of records to be generated by a GI.  On any GI that is pulling transactions, I use conditions and parameters to avoid sending “all” transactions to the screen. For example, add a required parameter/filter so the customer must choose a period or an account when showing transaction-level detail.

I hope this helps you.

View original
Did this topic help you find an answer to your question?

6 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+15
  • Captain II
  • 2183 replies
  • August 10, 2022

Hi @jmorgan 

Does the GI have the OData selected? There were a few posts regarding that:

Why is OData $select parameter so slow? | Community (acumatica.com)

 

If not, what is the data you are trying to pull for the GI? It could be how the GI is written and what the system is trying to search for. 


Forum|alt.badge.img+1
  • Author
  • Jr Varsity III
  • 51 replies
  • August 10, 2022

Thanks Kbeatty21

It is a GI executed within Acumatica.  We are not pulling the data externally from PowerBi.

James


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • August 10, 2022

Hello,

Look at what tables are being used and how they are joined. Incorrect joins can cause many multiples of records to be generated by a GI.  On any GI that is pulling transactions, I use conditions and parameters to avoid sending “all” transactions to the screen. For example, add a required parameter/filter so the customer must choose a period or an account when showing transaction-level detail.

I hope this helps you.


Forum|alt.badge.img+1
  • Author
  • Jr Varsity III
  • 51 replies
  • August 10, 2022

Thanks Laura,

That is useful

 

James

 


Gabriel Michaud
Captain II
Forum|alt.badge.img+10

@jmorgan if you have a specific GI that is problematic, feel free to export it and attach it here for review


apretorius62
Freshman I
Forum|alt.badge.img
  • Freshman I
  • 34 replies
  • November 14, 2023

I think a GI needs a "GO” button, because everytime you change a parameter (if more than one) it searches. Why net choose all your parameters and then click "GO”?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings