Are you asking for why it takes much longer in development or why it timed out? For timing out, what is your connection query time out set to?
For why it is taking longer in development, it could be a number of things. Generally, you would check proper indexing first. If not, then it may be environmental. At that point, you would look at cpu, ram, and disk usage. It could
also be that the production disks are much faster than development. Another possibility is that there are other processes in your development environment that is consuming a lot of resources as well. Then again, maybe your admin set your development
SQL Server instance to consume far less resources than production.
-
Edited by
J I M B O
9 hours 2 minutes ago