use sql_trace and trac it.

Is it returning data to the client?

If so you could have a network issue as its taking ages to return the data to you