There are several reasons that could cause a query or updates to take longer then expected. This could be due to network issues or it could even be due to the database design itself, but most of the time slow running queries are caused due to:
In any case, you should check the following in order to troubleshoot slow running queries:
While this is far from a complete troubleshooting guide, this should get you started…
Special thanks to Saleem Hakani for this information!