Importing 100,000 products into wordpress?

Question

WordPress

Hello. Tell me what to do.
Importing 100,000 products using the wp all import plugin. Import freezes at about 24,000 positions or loads after 24 to just one product in half an hour. Is there any way to speed up the process????
I use beget.ru hosting, VIP town tariff.
1. Imported 1 file in 100 k and divided by 1 k the effect is the same
2. If you install the product on Denver and then enable import on your computer, will the effect be better?
3. I read how people import into wordpress for 500k, why does my import stupidly die on a miserable 25k of goods?

Answer 1

There is a binlog in Mysql and it just fills up very quickly (30k products with 10 parameters, one picture and description will take ~ 100 GB), I assume that the hosting place for mysql is allocated separately and is not calculated from your tariff, but nevertheless their place is not rubber.
On Denver, you can test the same effect, it will work until the memory on your computer runs out.
Therefore, for such an import, a VPS is required, while completely disabling binlog at least for the duration of the import. wp all import itself is able to continue loading from the point of failure, therefore there is no particular point in splitting into parts, it breaks itself ... If you managed to start importing, then you should not worry about it.

Answer 2

It's all GUI charms. By SSH 500k sql dump will be imported once or twice. So if this data is already somewhere in the form of a working database, I suggest exporting the sql dump, uploading it via ssh and not worrying about it.