# Very slow import on a 64 core / 128gb server

**URL:** <https://forum.mautic.org/t/very-slow-import-on-a-64-core-128gb-server/29026>\
**Category:** Product Support\
**Tags:** mautic-4\
**Created:** [August 22, 2023, 3:55pm UTC](https://forum.mautic.org/t/very-slow-import-on-a-64-core-128gb-server/29026 "2023-08-22T15:55:10Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![dreccadin](https://avatars.discourse-cdn.com/v4/letter/d/e56c9b/32.png) [@dreccadin](https://forum.mautic.org/u/dreccadin)\
**Post date:** [August 22, 2023, 3:55pm UTC](https://forum.mautic.org/t/very-slow-import-on-a-64-core-128gb-server/29026/1 "2023-08-22T15:55:10Z")

</div>

**Your software**  
My Mautic version is: 4.4.9  
My PHP version is: 8.0.30  
My Database type and version is: 8.0.34 / mysqli

**Your problem**  
My problem is:

Running only a mautic installation on this server. Importing contacts is extremely slow. Just 500 contacts, 4 columns of data per contact.

Server is 64 core, 128GB, SSD. Very standard setup, and the marketing team needs this to work from the browser, they do not understand command line. Since this is the only thing running on the server though, it should be fine.

Importing 500 contacts takes over 25 minutes. And sometimes just times out.

These errors are showing in the log:

No errors in the log or on the server

Steps I have tried to fix the problem:

Set Mautic account on the server to have unrestricted use of CPU, Memory, IO, MySQL and all other things I could think about.

Changed PHP version to 7.4 and 8.0

Changed web server from Apache to Litespeed and back

Can’t think of anything else at this point…

Thank you in advance for the help!

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [August 23, 2023, 9:26am UTC](https://forum.mautic.org/t/very-slow-import-on-a-64-core-128gb-server/29026/2 "2023-08-23T09:26:46Z")

</div>

Hello!  
I urge you to check previous comments, cause this is a pretty popular question.

> [@Mautic CSV data importing very slow](https://forum.mautic.org/t/mautic-csv-data-importing-very-slow/28766/2):
>
> Hi, this can be the result of: not enough resources (you have a 1GB MEM server with 1 CPU and pay only like $20 for it) you DB doesn’t have index on email address in the leads table you have WAY TOO MANY columns in your csv you had an error and it stopped your cronjobs are not set or set wrong Here is an article to help you out: [How to import contacts to Mautic in the background without timing out - Knowledge Base](https://kb.mautic.org/article/how-to-import-contacts-to-mautic-in-the-background-without-timing-out.html)

If your resources are fine, then:

- check db index
- limit fields you import at once
- optimize cron

---

<div class="post-metadata">

**Author:** ![dreccadin](https://avatars.discourse-cdn.com/v4/letter/d/e56c9b/32.png) [@dreccadin](https://forum.mautic.org/u/dreccadin)\
**Post date:** [August 28, 2023, 9:00pm UTC](https://forum.mautic.org/t/very-slow-import-on-a-64-core-128gb-server/29026/3 "2023-08-28T21:00:42Z")

</div>

Hey Joey,

Appreciate the reply. The info you gave in the other post is what I already tried before posting. This is a beefy dedicated server, so it should handle a PHP app like Mautic really easily.

Database indexing, even on that specific table is set.

There’s only 4 fields per entry

Not using the cron at all. 1000 entries, 4 fields each. If I were to run this as a MySQL data point, this machine could complete this in a few seconds.

The delay is happening within Mautic, it seems to be processing things really slowly.

This is a 64 core, 128GB ram machine with absolutely nothing else running on it.

I’m at a complete loss as to what to try. I’ve exhausted the troubleshooting about things I know about, so is there some sort of process log or strace ability in Mautic to see where the delay in processing is happening and why?

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [August 29, 2023, 10:10am UTC](https://forum.mautic.org/t/very-slow-import-on-a-64-core-128gb-server/29026/4 "2023-08-29T10:10:21Z")

</div>

Can you plz setup an import, choose background processing.  
Then go to command line and execute the  
mautic:import command.

Here is some help:

> **[How to import contacts to Mautic in the background without timing out -...](https://kb.mautic.org/article/how-to-import-contacts-to-mautic-in-the-background-without-timing-out.html)**
>
> How to import large volumes of contacts to Mautic using the background cron job.

What do you see - are the contacts added really slow? Like 1-2 / sec?

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [November 7, 2023, 8:31am UTC](https://forum.mautic.org/t/very-slow-import-on-a-64-core-128gb-server/29026/5 "2023-11-07T08:31:41Z")

</div>

Here is a tip how to speed up the import speed:

[![](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/a/a2f5993cd087573ebc2feb622129c84b27cd14c7.jpeg "5 Minute Mautic Crafts: Import speed increase 5x") ](https://www.youtube.com/watch?v=RYybgkfmyv0)
