I work in a precious metals industry, where the prices of items change every minute depending on the market. At the base level, UnitPrice = MarketPrice + Premiums per level.
My questions are:
If we want to import MarketPrices into Magento, should we set up a cron job that runs every minute and get market prices via the REST API? I guess that's the only way but I want to confirm.
If we replace the feature that calculates the unit price of an item based on our price calculation logic (UnitPrice = MarketPrice + Premiums), do you see any problems, such as mysql indexes? Is UnitPrice indexed in Magento2. Do you see any risks?