Jump to content

13,000 Merge with 151 fields 28 hours to compose.


Recommended Posts

Greetings all,

 

We had a merge the other day that had 151 fields and 13,000 records to merge it took over 28 hours to compose the whole job.

 

My question is has anyone ran into a job with this many fields and know away to speed up composing it?

Link to comment
Share on other sites

I suspect that the composition speed has less to do with the number of data fields, and more to do with the number of frames. If that's the case, there's probably a way to reduce the number of frames by using things like tables. But without seeing the job, I'm just guessing.
Link to comment
Share on other sites

I suspect that the composition speed has less to do with the number of data fields, and more to do with the number of frames. If that's the case, there's probably a way to reduce the number of frames by using things like tables. But without seeing the job, I'm just guessing.

 

 

I started to suspect the same thing and have been working the frames down, but I am still at around 80 frames. which has gotten me down to about 4 seconds per record down from 8-10 seconds.

 

Thanks for the comment I will look into removing more of the frames.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...