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?

  • September 1, 2024
  • 2 replies
  • 28 views

WillH
Varsity III
Forum|alt.badge.img+3
  • Varsity III
  • 79 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. 

2 replies

Dmitrii Naumov
Acumatica Moderator
Forum|alt.badge.img+7
  • Acumatica Moderator
  • 772 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 III
Forum|alt.badge.img+3
  • Author
  • Varsity III
  • 79 replies
  • September 5, 2024

Thanks @Dmitrii Naumov  - appreciate the insight. :)