We can make use of the ‘Queue Number’ advance option to increase performance for the CSV import.
By default, all CSV import jobs use a single queue. This queue is defined as queue 1. It is possible to allocate import processes to other queues to improve the performance and save time. There are 1 to 5 queues are available.
In the import assistant, in the Advance options, select Queue number from the dropdown list.
Import jobs in each queue execute serially. For example, if there are two import jobs in queue 1, the first import job must complete before the second import job begins. Across all five queues, the import jobs execute concurrently. For example, if there is one import job in each of the five queues, all import jobs run at the same time.
The queue number selected for an import displays in the Queue column on the import Job Status page.
If you would like to change an import’s queue number during the time that it is in progress, you need to cancel the job and resubmit it with the new queue number.
- If the job has a status of Pending, you can step through the Import Assistant again to change the queue number and resubmit.
- If the job has a status of Processing, you need to download the CSV results file, which has entries for every canceled CSV file row. You would need to use this results file as the CSV file when you step through the Import Assistant again to change the queue number and resubmit.
Your queue number selection is preserved if the import is saved and rerun is the same account. The queue number is always defaulted back to 1 for a saved CSV import that is bundled, so that users in a target account where the bundle is installed can make their own queue selection.