Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Other Programming (https://www.askmehelpdesk.com/forumdisplay.php?f=437)
-   -   Query Slows down with internet (https://www.askmehelpdesk.com/showthread.php?t=44604)

  • Nov 24, 2006, 09:17 AM
    Grammarian-Bot
    Query Slows down with internet
    When I am using internet and SQL Server 2000 at the same time, my queries run slowly. Why? Is there any way to fix this problem?
    GB
  • Jan 9, 2007, 12:47 PM
    Slogmeister
    What exactly do you mean by "using internet"? Do you mean browsing? Is SQL running on your local machine, or are you running queries against a remote server? If you're running it locally, it takes a lot of cpu time and memory even when it's idle. If you're running queries against a remote server, well, then it's using the same bandwidth that you're using to browse the internet so they will naturally take longer. There isn't really a good way to "fix" the problem. You could get more memory or faster hardware if you're running it locally, but it will still chew up a lot of system resources. If you're using it remotely, you could get a faster network connection.

  • All times are GMT -7. The time now is 08:04 PM.