Re: SQL Server very slow over internet...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

It doesn't actually send all the data at once. If you profile the event I
think you will find a series of 1000 calls to the database to do the updates
or inserts. That's a lot of network traffic. Is this .net? If so how are
the updates or inserts being done? Is it a sp? Do you have SET NOCOUNT ON
at the beginning of the SP?

--
Andrew J. Kelly SQL MVP


<hurricane_number_one@xxxxxxxxx> wrote in message
news:1138315553.781086.111300@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I have an application that uses SQL Server and can be run on mutiple
> computers over a local area network. One of my clients has requested
> to have SQL Server running at their main office and have each client
> machine at a different location connecting to SQL Server over the
> internet. I have been able to set this up fine by just pointing the
> client machines to the main office PC by entering the server's IP in
> the client's DSN and opening up the SQL Server port on the main office
> computer's firewall but restricting access to only the IPs of the
> client computers. This all works fine except that when writing large
> number of records it's incredibly slow. If I'm writing 1000+ records
> in a LAN it wouldn't take very long but when I try the same over the
> internet it takes so long that I thought something was wrong and gave
> up waiting. I don't know how long it would take but I waited at least
> 30 mins and it didn't complete. I'm using disconnected recordsets so
> it should be sending all the data at once.
> Any idea why it would be running so slow? I would expect some slowdown
> over the internet but it is pratically non-functional. What can I try
> to speed it up??? I know the connection does work because it works fine
> for smaller number of records. Any suggestions?
>


.

Relevant Pages

  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I think it will ameliorate the situation if you clean up the client as ... And to come back to my problem: I think with help of the SQL Server admins ... closed connections - but all of these errors are in the version which used ... Every new client opens again 30 connections if I open 30 tables ...
    (microsoft.public.sqlserver.connect)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Please help - trying to return XML from a recordset
    ... SQL Server uses on the server, to prevent anyone having direct access to ... Internet that run SQL Server, but don't have port 1433 ... How do they allow the client application to interact with the ...
    (microsoft.public.inetserver.asp.general)
  • SQL Server very slow over internet...
    ... I have an application that uses SQL Server and can be run on mutiple ... computers over a local area network. ... to have SQL Server running at their main office and have each client ... internet it takes so long that I thought something was wrong and gave ...
    (microsoft.public.sqlserver.connect)