I am trying to import 10lac record via cli in a batch like 50k in fresh installed mautic version 6.0.6
inially it speed was 7 per sec but after import 1lac data now speed is gradually reducing it is now 3 per sec . It seems it will be very difficult to complete 10lac data import process. I have tried all memory configuration setting as well but still import process is struggling.
I kept 11gb for mysql 2gb for php out of 16gb.
Please guide how to improve import process more fast.
My Mautic version is: 6.0.6
My PHP version is: 8.3
My Database type and version is: Mysql