Cindy, one thing you could do is to drop the indexes on the forms into which you're importing the most records. That really speeds up submits.
Rick -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Cindy Sapochetti Sent: Tuesday, February 27, 2007 4:23 AM To: [email protected] Subject: How to speed up Import? Hi All - Importing slightly less then 200,000 records from our current system into Remedy (ARS 7.0.01 patch 001, CMDB 2.0.1 patch 002, BMC Asset 7.0.02 patch 003, SQL Server 2003, Windows 2000 Server) from the command line (arimportcmd) using a private queue. Due to the way the CMDB is structured, I'm importing to a form that has a number of display only fields, where I have workflow looking up the name of the form to import to (i.e. AST:ComputerSystem, AST:NetworkPort, etc.), then it pushes about 10 fields to the appropriate form. ARS Server and DB server are on separate boxes, so there is network to contend with as well. Within the limitations of what I've mentioned, does anyone have any thoughts on how to speed up the import? I thought about splitting the source file up, running it on several different private queues, but most of this particular import is going into one of two forms, so I'm not sure if that would help. Any advice from this experienced crowd? Thanks, Cindy ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
