I have 2 guesses

- May be the connection is eating time.

- The final query is missing join conditions.

Please review the asp code again for these two places.

OR

Send on the segment of...