Speed of internet

[Jose Perdigao]

I connected SQL Server from my FE created in access 2003 (ADP) from one
office to open a report spend 5 seconds, from another office and from
another coutry it spend about 20 seconds.

The time to open the report depend only from internet speed? Off course for
the same report, same BE and FE.
How can I know internet speed?

Thanks,
José Perdigão

 

[Sylvain Lafontaine]

My assumption would be that your first test is done on a local LAN while the
other is over the WAN. Typically, a LAN will be something like 100 times
faster than the WAN (with variations of 10x to 1000x and more). The
difference of 15 seconds comes from the lower speed of the WAN.

If speed is of concern to you, ADP (or worst, a MDB file with linked tables)
is not the best technology to use if you want to go over the WAN. Instead,
you should go with either ASP.NET or Winforms .NET: much more complicated to
develop than with ADP but much more faster over the WAN because only what
you want will go over the wire.

 

[Sylvain Lafontaine]

Other possibilities would be to use Terminal Server/Citrix ($$$) or
Replication.

 

[Jose Perdigao]

Thanks Silvan,
Any way, is possible to know the internet speed creating a function?

At the moment I must finish the ADP database and then, probably I will
change.
The access to SQL Server over internet (WAN) and using ADP as FE in one
place (place A), the speed to opne reports or forms is good, from another
place (Place B) is slow. I know in the place B, the internet speed is slower
but I don't know how I can see the speed.

Any suggestions?

Sylvan, do you know sites where can I learn about Winforms .NET?

Thanks,
jose perdigao

 

[Jose Perdigao]

Silvain, could you give me some sites about replications?
Thanks.
jose perdigao

 

[Jose Perdigao]

Hi Sylvain,



In this application, the difference between LAN and internet is 4s to 5s, is
very acceptable. I'm taking the connection in the office that I have good
internet speed.

Another place, spend 20sec. That's why, I would like to know how I can see
the internet speed,



Thanks,

josé perdigão

 

[Sylvain Lafontaine]

Well, obviously there should be many methods to know the average internet
speed of a particular connection; however I don't think that this newsgroup
is the best place to ask for this.

You should go to a newsgroup dedicated to windows, API or even TCP/IP.
Myself, I know a lot about ADP but I don't present myself as an expert on
networks.

 

[Sylvain Lafontaine]

Also, for more information in .NET technologies, either ASP.NET or Winforms,
you should go to any newsgroup dedicated to dotnet or to the Framework; such
as microsoft.public.dotnet.faqs, etc.

However, in your case, using something like Terminal Server will be a much
more easier and faster solution; even if this will cost you some $.

For Replication, take a look at microsoft.public.sqlserver.replication.

 

[J. Clay]

Jose - Another key is to make sure that the ADP is only asking the SQL
Server to send what it needs. Make sure you use stored procedures on the
SQL Server to filter out any data that is not necessary. This will help
your speed.

Also, internet speeds are NOT consistant. One day they may be incredibly
fast and the next they may be very sluggish. This is just the nature of
having so many diverse networks making up the internet.

J. Clay