fmsavey Posted September 19, 2006 Posted September 19, 2006 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!
Recommended Posts
This topic is 6640 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 accountSign in
Already have an account? Sign in here.
Sign In Now