Tweet
I have done a import around 2700+ data was there on the sheet with 97 columns, the file size was 5mb. But it took around 4 hour to complete the import. The import executed in idle mod. Skip duplicates and silent mode has not checked. Is there any way to fix this issue?
-
Last edited by Ashif Malayil; 05-10-2024, 09:59 AM. -
Enabling the skip duplicate will make it faster, silent mode also make it faster, especially if the table has large number of records -
For example, an import file of 18,000 lines on a very powerful server without the Skip searching for duplicates option but wiht Silent mode option enabled takes about 10 minutes (screenshot 1).
So, most likely, your server is simply too weak. You can enable Skip searching for duplicates and Silent mode and try to import through the UI, or better through the CLI.Attached FilesLast edited by victor; 05-10-2024, 10:37 AM.Comment
-
-
Adding necessary indexes may held if search for duplicates performs long. Also maybe consider upgrading server's hardware.If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.Comment
-
4 Core 16 GB RAM 250 GB SSD server? is this two weak?Comment
-
Server is not weak. The text is not boldenough.If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.Comment
-
Try to figure out what exactly is slow. Is it fast if you skip duplicates. Is it fast in silent mode.
How many records are already in the database table.
Database tweaking is also may be reasonable if you have big tables.
If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.Comment
Comment