>Splitting the processing would make it work. Thanks.
>One more question please, Could Web Service be another solution in this scenario? or would it be too slow.

Yes it may be a solution if you can move your processing into a COM DLL and result set returned is not too big.