Service Connect slowness

Hello there

Quick question for the community. We currently use Service Connect to bring orders over from our e-commerce site. It seems large orders take a long time, 100+ lines or more. A long time would be an hour or two. Some have told us this is par for the course with Service Connect as it mimics a user siting at a client workstation. Just curious what others experience working with Service Connect.

On a side note the servers involved are not maxed out on resource usage. Also our PLM traffic has the same behavior. And it does not matter the time of day when this occurs.

Thanks
Greg

in my experience that seems a bit excessive even for service connect.

Service Connect workflows can be written very poorly… Who wrote yours? How old is it? SC is not the fastest thing in the world but an hour seems excessive

4 Likes

Agreed. I’d be curious what an E10 server log would show for activity. Where is the time being spent?

Agree completely with Jose. Service Connect IS slow, but you can make it crawl really fast with some poorly written workflows. I’ve seen workflows that do a GetByID on the entire order for every line. Sit down with a 100 line order in front of you and hit refresh 100 times, that’s the overhead the workflow is adding to it.

Kevin

1 Like

I know when we have orders with so many lines it even slows the client unless we change the Users SysConfig file. Though I have no idea if you can do that to Service Connect. Also agreed with others the SC can be a bit slow and poorly created workflows really can bring it to it’s knees.

1 Like

Thanks for the feedback. Did some logging earlier but will definitely go back there and see about tuning in the workflow with our developer.

I agree three about the speed. But I can tell you it is way faster in 10 than 9

1 Like

It’s already covered, but I’d also support looking hard at the workflow. We’ve been through this, and many developers attempt to be too literal in “following what a user does at a workstation”. They will give you a workflow that mimics a user trace when there are far more efficient ways.

By comparison, I’ve yet to see a 100-line order come in from our website, but 30-line ones take 5-10 seconds for us, I think.

This is why I like the DMT tool so much better for importing data when I can use it instead.

1 Like

Thanks again everyone. Great feedback! After some more in depth tracing we found some more questions, but on a path to correcting it.

1 Like

I know I’m late to this thread, but I’ve used DMT traces to simplify some of my code. It would work for ESC too. If you want to mimic something, do it from the DMT. It’s supposed to be the best known process for mass import.

3 Likes

Nice trick Jason.