Drupal Commerce and large product inventories
The Akademika case study might help. They're at 18 million products right now, regular MySQL database plus Elasticsearch.

You can find the NyMedia team in #commerce on Drupal Slack (or contact them directly).