I have a web page with a database lookup that contains multiple optional parameters.
When I select a couple of parameters and run the query, it returns in less than two seconds.
However, when another person logs in, and runs the same query with the same parameters on my machine, it takes 30+ seconds to come back.
Web browser doesn't matter, it behaves the exact same way in multiple different browsers for each user.
Both users have all the needed permissions on the database to run the query as they go through the same database connection using TCP/IP.
At this point, the only difference is who is actively logged in, which doesn't make any sense to me. Does anyone have any ideas as to why the person would make a difference when everything else appears to be the exact same?