Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Scripting for High Volume Data Load
- Thread starter Craig511
- Start date
Archimedez
Instructor
My colleagues and I have a great deal of experience with scripting data into/out of MIMS. My general advice is that up to ~5000 rows is scriptable: beyond that, use a COBOL loader. (I absolutely do NOT recommend that you SQL directly to the database - BADMEANUGLY things happen). COM-based loaders run more efficiently with "MSQ" data than with "MSO" data; roughly 60 - 65 records per minute.
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question