antoine_mpo
Reputable Poster
Hi list,
Does anyone set up something to get the real processing time of UBE ?
I mean : when you submit an ube, a new record is added in F986110, with a submitted date and time.
When the ube is finished (done, or error), the last activity date and time is updated.
But if you calculate last activity - date/time submitted, you don't know how long it stayed in "P" (Processing) status. If an ube has been running for 1 hour in the mono-threaded queue before, the ube after will have at least one hour in the calculation, even if it took 1 seconds to proceed.
I thought of creating a custom table and a trigger on the F986110 to record the processing time.
Did someone already did that ? (or anyother solution) ?
But my fear is the performance impact ... In production, we have more than 10 000 ube by day !! (not all in the same queue of course !
If we had those kind of statistics, it would be easier to set up queues to balance ube on the diffirent queues considering how long they really take.
Any help would be appreciate.
Cheers,
Does anyone set up something to get the real processing time of UBE ?
I mean : when you submit an ube, a new record is added in F986110, with a submitted date and time.
When the ube is finished (done, or error), the last activity date and time is updated.
But if you calculate last activity - date/time submitted, you don't know how long it stayed in "P" (Processing) status. If an ube has been running for 1 hour in the mono-threaded queue before, the ube after will have at least one hour in the calculation, even if it took 1 seconds to proceed.
I thought of creating a custom table and a trigger on the F986110 to record the processing time.
Did someone already did that ? (or anyother solution) ?
But my fear is the performance impact ... In production, we have more than 10 000 ube by day !! (not all in the same queue of course !
If we had those kind of statistics, it would be easier to set up queues to balance ube on the diffirent queues considering how long they really take.
Any help would be appreciate.
Cheers,