Jump to content

Import with Update Matching


fmsavey

This topic is 6452 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I routinely run an import with update on matching fields and add new records a couple of times a day. Only one field is specified as a match. Typically I import about 3000 records from an ODBC source. Problem is... after a couple of imports, it begins to slow down from several hundred records per second to one record per second. At that point it is taking 50 minutes to import all the records. This is just unacceptable. I don't understand why this is happening. When I recover the file the performance picks up but then after one or two updates it back to a crawl. HELP!

Link to comment
Share on other sites

This topic is 6452 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.