# Importing large amounts of records

**URL:** <https://www.dolibarr.org/forum/t/importing-large-amounts-of-records/22121>\
**Category:** Using my Dolibarr\
**Tags:** Import-Assistant, v14\
**Created:** [April 5, 2022, 8:49pm UTC](https://www.dolibarr.org/forum/t/importing-large-amounts-of-records/22121 "2022-04-05T20:49:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![karozans](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/k/439d5e/32.png) [@karozans](https://www.dolibarr.org/forum/u/karozans)\
**Post date:** [April 5, 2022, 8:49pm UTC](https://www.dolibarr.org/forum/t/importing-large-amounts-of-records/22121/1 "2022-04-05T20:49:05Z")

</div>

Hi everyone. I am trying to import about 90,000 thirdparties using the Import Assistant.

It seems to work fine for maybe like 10,000 records or less, but anything more than that seems to take forever to import. I have increased the memory of PHP and the script run length, but it still seems to take far longer than an hour to complete.

Has anyone imported lots of records like this? Is there anyway that this can be sped up?

Thanks

---

<div class="post-metadata">

**Author:** ![pcbleu](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/pcbleu/32/3120_2.png) [@pcbleu](https://www.dolibarr.org/forum/u/pcbleu)\
**Post date:** [April 6, 2022, 11:38am UTC](https://www.dolibarr.org/forum/t/importing-large-amounts-of-records/22121/2 "2022-04-06T11:38:18Z")

</div>

Hey 🙂

I think you might try to do this directly with a sql script  
That is the way I use to migrate old erp datas to Dolibarr

For more information [see this link](http://www.bluelinecompany.fr/dolibarr/htdocs/custom/llstats/index.php?username=demo&idpro=&idtyppro=&dumpdata=) - login:demo, password:demo

Good continuation

---

<div class="post-metadata">

**Author:** ![karozans](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/k/439d5e/32.png) [@karozans](https://www.dolibarr.org/forum/u/karozans)\
**Post date:** [April 6, 2022, 1:39pm UTC](https://www.dolibarr.org/forum/t/importing-large-amounts-of-records/22121/3 "2022-04-06T13:39:35Z")

</div>

Hi. Thanks for the reply.

I thought about doing it with SQL scripts, but I wanted to make it where a non-technical customer of mine could perform the import without any help.

I’ll have to see what my options are. Thanks.