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
  • 21 views

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.

 

@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. 

Thanks @Dmitrii Naumov  - appreciate the insight. :)

Reply


Terms & ConditionsCookie settings