# Import speed issue
**URL:** https://forum.mautic.org/t/import-speed-issue/28436
**Category:** Product Support
**Tags:** mautic-3, mautic-4
**Created:** [June 26, 2023, 4:21pm UTC](https://forum.mautic.org/t/import-speed-issue/28436 "2023-06-26T16:21:49Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@raj11111](https://forum.mautic.org/u/raj11111)
#### Post date: [June 26, 2023, 4:21pm UTC](https://forum.mautic.org/t/import-speed-issue/28436/1 "2023-06-26T16:21:50Z")
**Your software**
My Mautic version is: 4.4.9
My PHP version is: 8.0
My Database type and version is: marizdb 10.4
**Your problem**
My problem is: Import speed issue
These errors are showing in the log: nothing
Steps I have tried to fix the problem: I have optimized mysql, PHP also i have upgarded the server with dedicated 32GB RAM 8Cores and 2TB drive.
Hello experts,
Nice to meet you
I’m getting list import issues with my mautic application
anybody here who can assist me to fix the import issue?
let me give you brief about the issue once.
When I am importing a list in mautic then the list import process goes on but the contacts are getting imported very slow which should be fast, and there is no option in mautic from where we can regulate the speed, and i have also checked from server nothing is there which can creates the issue.
---
### Author:  [@joeyk](https://forum.mautic.org/u/joeyk)
#### Post date: [June 27, 2023, 7:40am UTC](https://forum.mautic.org/t/import-speed-issue/28436/2 "2023-06-27T07:40:34Z")
Hi, we need a bit more info.
What is the speed you have achieved?
Slow means: 1-2 / sec
Normal for me means: 30k imported in 8-12 min
With your resources and properly configured database you should achieve 100k/hour 20min.
---
### Author:  [@raj11111](https://forum.mautic.org/u/raj11111)
#### Post date: [June 27, 2023, 9:23am UTC](https://forum.mautic.org/t/import-speed-issue/28436/3 "2023-06-27T09:23:23Z")
Hello Joeyk,
No, i’m not getting this import speed as you mentioned if i get this import speed i’m will be setisfied No, i’m not getting this import speed as you mentioned if i get this import speed i’m will be satisfied, but currently the import spped in my mautic is 1 sec 1 email, and when i upload 15K list it taking 2.5 Hours to import completely.
Exactly i’m getting this
Slow means: 1-2 / sec
resources wise i’m using dedicated server with 32GB RAM, 8 Cores processor, and 2TB NVMe Drive.
---
### Author:  [@joeyk](https://forum.mautic.org/u/joeyk)
#### Post date: [June 27, 2023, 11:47am UTC](https://forum.mautic.org/t/import-speed-issue/28436/4 "2023-06-27T11:47:32Z")
Okay, I noticed it - happens if you have issues with indexes.
Can you check if you have the email column indexed in your leads table?
In mysql:
DESCRIBE leads;
---
### Author:  [@mikew](https://forum.mautic.org/u/mikew)
#### Post date: [June 27, 2023, 1:25pm UTC](https://forum.mautic.org/t/import-speed-issue/28436/5 "2023-06-27T13:25:15Z")
Hey @joeyk
jumping in with my answer to your question, mine looks like this
```auto
| email | varchar(191) | YES | MUL | NULL |
```
---
### Author:  [@joeyk](https://forum.mautic.org/u/joeyk)
#### Post date: [June 27, 2023, 1:43pm UTC](https://forum.mautic.org/t/import-speed-issue/28436/6 "2023-06-27T13:43:44Z")
Correct.
BUT if you have
| email | varchar(191) | YES | NULL | NULL |
In other words email is not indexed as multiple, your import speed will suffer.
Joey
---
### Author:  [@mikew](https://forum.mautic.org/u/mikew)
#### Post date: [June 27, 2023, 2:00pm UTC](https://forum.mautic.org/t/import-speed-issue/28436/7 "2023-06-27T14:00:04Z")
aha, okay good 😃
what would be the case that it is not indexed? or not MUL
---
### Author:  [@joeyk](https://forum.mautic.org/u/joeyk)
#### Post date: [June 27, 2023, 2:00pm UTC](https://forum.mautic.org/t/import-speed-issue/28436/8 "2023-06-27T14:00:59Z")
Nono, yours is file. You have “MUL”, thats good.
---
### Author:  [@joeyk](https://forum.mautic.org/u/joeyk)
#### Post date: [June 27, 2023, 2:52pm UTC](https://forum.mautic.org/t/import-speed-issue/28436/9 "2023-06-27T14:52:43Z")
NUL or empty is not indexed
---
### Author:  [@raj11111](https://forum.mautic.org/u/raj11111)
#### Post date: [June 27, 2023, 5:31pm UTC](https://forum.mautic.org/t/import-speed-issue/28436/10 "2023-06-27T17:31:24Z")
Hi,
I have checked you describe and i found this in my DB.
email varchar(191) YES NULL
Is it good or bad?, and if due to this the import speed is slow then how i can edit or update the index?
---
### Author:  [@joeyk](https://forum.mautic.org/u/joeyk)
#### Post date: [June 28, 2023, 8:34am UTC](https://forum.mautic.org/t/import-speed-issue/28436/11 "2023-06-28T08:34:59Z")
We don’t know if it’s bad, because the info is not visible.
You are pointing at the “default value” and we need the indexes.
Plz give this command in SQL and see what you get for email:
`DESCRIBE leads;`
---
### Author:  [@joeyk](https://forum.mautic.org/u/joeyk)
#### Post date: [June 28, 2023, 10:30am UTC](https://forum.mautic.org/t/import-speed-issue/28436/12 "2023-06-28T10:30:44Z")
Actually I can see, that you don’t have an index.
Run this command:
```auto
CREATE INDEX idx_email ON leads (email) USING BTREE;
```
Check speed now
---
### Author:  [@bobkitz](https://forum.mautic.org/u/bobkitz)
#### Post date: [September 30, 2023, 7:34pm UTC](https://forum.mautic.org/t/import-speed-issue/28436/13 "2023-09-30T19:34:12Z")
Thank you! This solved my problem as well. I wonder why this field is not indexed by default?
---
### Author:  [@joeyk](https://forum.mautic.org/u/joeyk)
#### Post date: [October 1, 2023, 10:01am UTC](https://forum.mautic.org/t/import-speed-issue/28436/14 "2023-10-01T10:01:01Z")
I’m not sure. For me it’s standard procedure to add it. 🙂
---
### Author:  [@system](https://forum.mautic.org/u/system)
#### Post date: [October 2, 2023, 10:01pm UTC](https://forum.mautic.org/t/import-speed-issue/28436/15 "2023-10-02T22:01:08Z")
This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.