Very slow contact import in Mautic v7.x

Product Support
1

Your software
My Mautic version is: 7.1.1
My PHP version is: 8.3.30
My Database type and version is: mariadb: 10.11.16

Your problem
My problem is:

Hello Mautic community,

I am currently working with a project based on Mautic Open Source 7.x, running in Docker with the following environment:

  • Mautic 7.x
  • MariaDB 10.11
  • Mautic container: mautic/mautic:latest
  • Background imports executed with:
php bin/console mautic:import --no-interaction

For testing, I divided the contacts into three CSV files containing 23,400 rows each and configured:

'parallel_import_limit' => 4,

I then started three import processes simultaneously. All contacts were new and the database was clean.

These were the results:

Import 1:
23,400 contacts created
Time: 795.21 seconds

Import 2:
23,400 contacts created
Time: 793.56 seconds

Import 3:
23,400 contacts created
Time: 790.44 seconds

The actual total elapsed time was approximately 13 minutes and 24 seconds for 70,200 contacts.

Can I improve this time?
Is there another solution that allows for faster importing?