Page 1 of 1

Delay in record processing by TI Process

Posted: Thu Apr 17, 2014 9:32 pm
by zodiacviv
Hi Everyone,

I am currently facing an issue in TI Process that is working fine in functionally but while processing records, i am not getting usual behavior as TI process should display. I am using this TI to process around 2 Lakhs records and up to 50K records, it takes very less time that is normal but after that it takes more time to process each record and time taken to complete processing all records is around 10 times to time taken to process 50k records. Please help me with possible reasons that what can be issue here that is causing this delay. Your expert opinion is highly appreciated. :)

Re: Delay in record processing by TI Process

Posted: Fri Apr 18, 2014 3:47 pm
by java_to_tm1
What is the TI process doing?
cube loads? or dim modifications as well?

It is tough to help without further details.

Please remember that the word 'lakh' (meaning 'a hundred-thousand') is not in common usage outside of the Indian sub-continent.

Your problem seems to be that with 4 times as much data (200,000 / 50,000) , you'd expect the process to take 4 times longer, but it is actually taking upto 10 times longer. are there any other processes running at the same time? Is your process ever going into a 'wait' state?