Optimal number of control and info parameters on event handler

[Former Member]

Hello Guru’s

We have integrated TM and EM for FO tracking, in few scenarios FO can have more than 200+ FU’s assigned to it.

We are using “ODT20_ASSIGNED_FU” control parameter to hold assigned FU’s information on EH, is it good to have more than 250+ control parameters on a EH? Is there any suggestion on optimal number of control and info parameters on event hanlder.

We also have FU’s as tracking ID’s on FO.

Thanks in Advance,

Vishwa.

[Former Member]

Hi,

Vishnu, Daniel and Gopi thank you for your valuable suggestions.

Vishnu:

Sure, we will consider moving the parameters evenly across control and Info parameters.

Regarding Archiving still we have not considered archiving option which will be on-boarded soon, suggestion is Archiving should be considered after go-live after observing data growth as a separate project.

Daniel:

Sure I will consider "Disable Loading of EH Data for Processing of Event Messages" on EH type after few basic cross-checks.

Thank you for your suggestion.

Gopi:

In my case, we are not going more than 200+ parameters, but, one of the parameter "Assigned freight units" can have more than 200+ values on FO event handler.

Yes, we are using EM web UI for reporting events - and we have not gone beyond 15 parameters (columns) on EM web UI display

My only concern is more than 200+ parameter values for assigned FUs.

Regards,

Vishwa.

[Former Member]

Hi Viswa,

1. We suggested earlier, yes it will have impact the system performance.  Do one thing, do the prototype in development for one of parameter which you said.  Send 200+ values for 10 FO event handler at same time and calculate the time how long it takes.

Take that calculation and calculate with your production peak data hours how many FO event handlers create and update in an hour to check performance side.

2. I know many organizations do not have archiving strategy and they are keeping more than 5 years data and  billions of transactions in system and they are just increasing the hardware inside.

If you think the FU update lesser than 10000 per day then you may go ahead with 200+ values for one of parameter update.

Check the calculation per day volume and let us know.  Let's precisely address this what would be the impact current and future.

I have see some project loads 2 million of data without any issue but has lesser parameter value on parameters.

Regards

GGOPII

[Former Member]

Hi Vishwa,

Additionally,

You can separate the parameters based on the your Ruleset, WEBUI. What I mean is see if you can put all the parameters which are used in ruleset in Control parameters, WEBUI selection screen in System Parameters and WEBUI display parameters in the INFO. This way you are segregating the parameters on need basis which will help in your system performance.

There maybe few parameters which might be applicable for both Ruleset and WEBUI though and you can decide where to put it based on how many you have in Control and Info.

Thanks,

Vishnu