Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Requirements: MODORDERS-488 Investigate transition of Orders search to cross-index subqueries

Overview:


Endpoints calling views:

/orders-storage/receiving-history  → receiving_history_view




/orders-storage/orders  → orders_view




/orders-storage/po-lines  → po_lines_view



/orders-storage/order-lines  →  order_lines_view


Prepared a POC with migration of this endpoint from searching accross the views to the searching via cross-indexes

...

Results of the search via cross index approach:


As you can see every search requests takes less than 200 ms

Image Added


So switching implementation from views to the cross index search improves perfomance about 10 times.