What impact does Magento 2's indexer mode have on bulk import performance and frontend data freshness?
Goal: Determine whether keeping indexers in Update on Save mode during bulk product imports creates a measurable admin response time bottleneck that outweighs the risk of stale frontend data when using Schedule mode. Constraints: The store runs Magento Open Source 2.4.5 in production mode, cron is configured to run every five minutes, and the admin panel is