You might be having a loop through and takes much time for the final SELECT statement to work. When you stop the query and run the final select statement it produces whatever records you have on it based on the data generated until the point where you cancelled. Better to see the actual query and can help accordingly.
Cheers
Dr.Subramani Paramasivam
No comments:
Post a Comment