Index Times takes so long in magento 2.3.2

[dimitrios_gogou]

Hello I would like to ask a few things about Indexing.
I am using Magento 2.3.2 and i am building a website in localhost. Until now i have imported 45.000 products.
I runned index and it took about 9 hours for 45.000 products! please see bellow times.

    info@LAPTOP-5SEJ1RGM c:\xampp\htdocs\gigaparts'

    php bin/magento indexer:reindex

    Design Config Grid index has been rebuilt successfully in 00:00:00  
    Customer Grid index has been rebuilt successfully in 00:00:00  
    Category Products index has been rebuilt successfully in 05:12:13  
    Product Categories index has been rebuilt successfully in 00:00:00  
    Catalog Rule Product index has been rebuilt successfully in 00:00:00  
    Product EAV index has been rebuilt successfully in 00:00:29  
    Stock index has been rebuilt successfully in 00:00:11  
    Inventory index has been rebuilt successfully in 00:00:00  
    Catalog Product Rule index has been rebuilt successfully in 00:00:00  
    Product Price index has been rebuilt successfully in 00:03:55  
    Catalog Search index has been rebuilt successfully in 03:25:39

What if i reach 500.000 or 700.000 references? how long it will need?
Also lets say i am at 700.000 and i add one more reference. (I will import new references through ERP system linked to magento).
How long will it need to appear to my site?
Are these times normal? Or there is a bug?
Should i try different magento version? Please advise.

[Meetanshi]

Hello @dimitrios_gogou 

You need to set up cron in Magento 2

When you set up Magento 2, it is compulsory to set up cron.

So, when the cron runs according to the schedule, the tasks are completed automatically.

And, it won't take more time in indexing.

Hope it helps.

[dimitrios_gogou]

Hello

So what if i reindex now, upload to live server setup crons, and then i change for exaplme prices in all my products, will this need again index that takes 48 hours? If this is the case then my server will have overload for 2+ days. 

[theMageComp]

Hello

If you are going to change the price of all the products all at once, then it may need sometime,

You can setup cron as @Meetanshi suggested of 24 hours on your server.

Also i would advise you to use the good and Magento optimized server like Nexcess or Fastcomet Cloud Servers

[thaohphome6314]

Hi there,

Actually, your problem is quite common because Magento default takes a lot of time to reindex data. More than that, I think it’s complicated to run the command lines as well.

Therefore, the best solution for you is to install a Magento 2 Reindex extension. 

This supports you to actively control the reindexing process right from the admin panel with a few simple clicks. 

Without specialized technical knowledge, store admins can still start the reindexation process, start or end reindexing, as well as manage outdated reindex status.

It can reindex all data automatically, so it saves up a great deal of time and effort.

Hope it can help you solve your current problem.

Have a nice day.