Skip to main content
Solved

When did the Perfromance guidance in I320 for list Sales orders with details & shipments change from make 2 requests to make 1 request?

  • 2 September 2024
  • 2 replies
  • 22 views

WillH
Varsity II
Forum|alt.badge.img
  • Varsity II
  • 35 replies

Hi Acumatica community,

This is more for my personal interest/because I like to understand things.  I figured a long time developer might know.

 

In-between when I initially sat I320 and when I’m redoing it now, the guidance in the course changed.

The new guidance is to send 1 request, with a double expand if you’re retrieving records from.

 

So I have 2 questions:

  1. When did the guidance change?
  2. Why did the guidance change? (Technical perspective)

 

I spend a fair amount of time explaining reasons for choices to implementers/developers, and while I’ll certainly follow I320 it helps to understand why the guidance changed.

 

Screenshot of i320 Question: Suppose you need to retrieve detail lines & shipment lines of multiple sales orders.

 

Best answer by Dmitrii Naumov

@WillH I think it changed in ~ 2019 R2.

The reason for this is that previously double expand was not supported for GetList method. Now multiple expands are properly supported and build an optimized SQL query. 

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

2 replies

Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+6
  • Acumatica Moderator
  • 595 replies
  • Answer
  • September 3, 2024

@WillH I think it changed in ~ 2019 R2.

The reason for this is that previously double expand was not supported for GetList method. Now multiple expands are properly supported and build an optimized SQL query. 


WillH
Varsity II
Forum|alt.badge.img
  • Author
  • Varsity II
  • 35 replies
  • September 5, 2024

Thanks @Dmitrii Naumov  - appreciate the insight. :)


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