How many records at a time should be imported in import set table for better performance?

[azam110]

I wants to import bulk data from CSV file to an import set table?

What amount of data(number of rows) should i import for better performance, which do not create any issue?

[azam110]

https://instancename.service-now.com/sys_import.do?sysparm_import_set_tablename=filename&sysparm_tra...

[azam110]

the uploadfile parameter i am sending in the form data as a file attachment

[Ashutosh Munot1]

HI Azam,

There is no such limit. But performance depends on what rules you give in transform maps and fields maps.

Are there any additional scripts call from transform maps before putting data to target table.

I have a import set which has 60k records with some additional scripts and processing into this, so it takes 4 to 5 hours to complete and process all records.

Thank you,
Ashutosh munot

[azam110]

Hi Ashotosh,

I am import the records using the post url below

https://instance.service-now.com/sys_import.do?sysparm_import_set_tablename=table_name&sysparm_trans...

I am not putting any business rule or running any script for now. I just want to import the record in import set table and transform it using the above url.

Please suggest what maximum limit of record should i put in the csv file   at a time to pust it inti import set table.

Thanks

Azam

[sergiu_panaite]

You didn't get it. There is no limit you need to set. The more records you have to import, probably the longer will take. This doesn't mean that there is a performance issue, it just takes longer.