I have 2 transactions T1 and T2. T1 is called through an xacute query from an iCommand on a .irpt page. T1 does some logic and calls T2 a couple times before returning data back to the page.
The logic works fine and when I test T1 in the workbench it runs in about 300 ms.
The problem is when I call T1 from the web page it is taking up to 10 seconds to proccess the transaction. When I look through the transaction manager at the log for T1 and it says the execution time is 10000 ms.