siplus

Performance question on related records

Discussion created by siplus on Sep 28, 2018
Latest reply on Sep 28, 2018 by siplus

In a solution hosted on FMS and used on local LAN there is an invoice table and a line items table.

Users are browsing through invoices, looking at line items and at the invoice total.

 

In line items we have a linePrice value and a summary, linePriceTotal.

 

There is ofc a relationship, invoice_lineItems that sends the line items and also delivers the invoice total via invoiceLineItems::linePriceTotal.

 

Here is my question:

 

Would the browsing be faster by defining a second relationship, invoiceLineItemsForTotals, identical to the already existing one, and by separating the job in 2 different tasks (maybe the server can run them in parallel ?)

 

- give line items via Relationship 1

- give the total via Relationship 2

 

the idea is extensible, adding another Relationship to calcutate VAT etc.

 

Any ideas ?

Outcomes