Tarun, Did you test the Mid-tier after you tested the User tool? ( Maybe your RDBMS cached some table in memory and made the second time the process was run "faster" due to the in memory cache?)
Also... How much activity is there in "Active links" for this? (AKA: are you looping over a table field?) If so then how the Mid-Tier deals with processing active link workflow might have something to do with that part being different. But I really think it is more likely to be the other idea.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. Never ascribe to malice, that which can be explained by incompetence. On 7/27/06, Tarun Kumar SHARMA <[EMAIL PROTECTED]> wrote:
Hello, We are doing some activity on 'button' click and this activity is quite heavy. This process is searching an entry in SHR:Assignment form and do some comparison with every record of assignment and finally transfers this record to a separate form with all other checks. Nearly 30-35 remedy objects(filters and active links) are used in this process. This activity is taking 30 minutes on Native Client; when we did this on Web, it is surprisingly taking 3 minutes for the whole activity. We compare the results of both and found no mismatch. Everything was looking fine except the time difference. Can you please suggest why so much difference in time ? Regards, Tarun Sharma
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org