I am using Smart
While analyzing the various IDA calls fired within the application , we came across the call timings captured within “isc_RPCResponseStart”.
Table below show the time taken (in secs) at different steps of IDA request processing returning ~147K records.
Total time taken to process the IDA call was around 44 Sec out of which almost 80% (35Secs) is consumed by DSResponse Serialization process to transform147K of records. But if we run the same query for 10K record this process take less than 1 sec.
We need your help to identify the way to minimize this cost.
Thanks a lot.
GWT version -> v9.0p_2013-07-29/PowerEdition Deployment (built 2013-07-29)
Table below show the time taken (in secs) at different steps of IDA request processing returning ~147K records.
Code:
----------------------------------------------------------- Processing Step Name Time Taken (in Secs) ----------------------------------------------------------- "Server processing" 44 "RPCManager processing" 9 "query" 1.5 "SQLTransform" 7.5 "DSResponse serialization" 35
We need your help to identify the way to minimize this cost.
Thanks a lot.
Comment