Skip to Content
0
Former Member
May 25, 2010 at 07:09 AM

Performance of import server is prohibitively slow

227 Views

Our production server imports data at a rate of 1 record/second. In development with much smaller dataset in repository, the import is 50x faster. The time is spent during the step GetMatchedNumberForRecordValues

Our table being imported has 5 key values; it has 6m rows. I know its quite large, but in DB world we have seen tables more than 6m rows....

Has anyone seen this problem? what solution did you find?

for mass or bulk import of data( MDIS OR IMPORT MANAGER ) Which one is the best ? can any tell explain clearly why ?

Thank you in advance.

Vijayakumar Maddula