Be sure to turn off the default audit trail on the CTM:People form. Why do you need the staging form?
- Jarl On 10/15/07, William Rentfrow <[EMAIL PROTECTED]> wrote: > ** > > On my current project we will have to import about 1,000,000 CTM:People > records every week (give or take). These will be "new" records every time > because the only unique identifier we have from the external systems is an > identifier like SSN that we can't put into our system (that's a policy > decision). We're checking on ways to do updates but it's still messy due to > the item below. > > The actual import is going to be automatic and should follow this process: > > 1.) Escalation deletes all relevant CTM:People records > 2.) File is automatically put on the Remedy server with people information > 3.) Escalation fires a Run Process that imports the data into a staging > form. > 4.) Escalation fires and sets a flag field to "Process Now" on all records > in the staging form > 5.) Filter on "modify" on the staging form pushes to CTM:People > > Here's the problem - we're using decent hardware running on Solaris 9, etc - > yet the push to CTM:People takes 1.5 seconds per record due to all of the > validation that takes place. > > I have to do 1,000,000 records a week - and there are only 604,800 seconds > in a week....also, it appears using direct SQL loads won't work due to all > of the back end set fields (I can get around all of those except the GUID - > which could be set by another escalation.....and then we are back at this > same problem). > > If you've done large data imports to CTM:People I'd really like to know how > you went about loading the data efficiently. > > William Rentfrow, Principal Consultant > [EMAIL PROTECTED] > C 701-306-6157 > O 952-432-0227 > __20060125_______________________This posting was > submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"