Slow Import

[Ashif Malayil]

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?

[eymen-elkum]

Enabling the skip duplicate will make it faster, silent mode also make it faster, especially if the table has large number of records

[victor]

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?

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.

[yuri]

Adding necessary indexes may held if search for duplicates performs long. Also maybe consider upgrading server's hardware.

[Ashif Malayil]

4 Core 16 GB RAM 250 GB SSD server? is this two weak?

[yuri]

Server is not weak. The text is not boldenough.

[yuri]

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.