Skip to end of banner
Go to start of banner

Spike: [MODORDERS-488] Investigate transition of Orders search to cross-index subqueries

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

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


Performance improvements:

For the perfomance testing purposes I have prepared data loading script which creates 100 purchase orders and 50.000 PO lines in total. Each poline slightly differs from other only by listUnitPrice, so search requests will be performed quering this field by value.



  • No labels