Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Mon Mar 7 14:03:35 CST 2005
Bare in mind that that speed is not fully available to your app. If they have the need for that kind of WAN speed, this means that they probably already consume a lot of that speed for other reasons (VoIP is one example). Your speed will be effected by other applications that are used. A WAN connection has also some overhead depending on the protocols they use, so the bandwith is not fully available for real data. This depends on the WAN protocol used, can be up to 10% depending on the situation. Further more if they use QoS able protocol (Frame Relay/ATM) some other apps can have priority over yours, posibly terminating your connections. Like for VoIP. Is this a Leased Line? Some people believe they have a high speed connection with for example ADSL or cable. This is not fully true. The upstream speed is often very much limited. Me personaly I would not use an MDB as a backend over a WAN line. Too sensible for corruptions. Erwin -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Monday, March 07, 2005 8:53 PM To: 'Discussion of Hardware and Software issues' Subject: RE: [dba-Tech] Access Performance on a WAN Thanks Bobby - that does help! -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Bobby Heid Sent: Monday, March 07, 2005 1:10 PM To: 'Discussion of Hardware and Software issues' Subject: RE: [dba-Tech] Access Performance on a WAN Dan, Latency is the amount of time it takes for a data packet (i.e., a unit of data) to move across a network connection. Latency and bandwidth are the two factors that determine the speed of your connection. An example is with a hard drive, latency in this respect is the time between requesting the data form the HD and the actual transfer starting. One of our clients wanted to do some stuff over a slow WAN that had network problems. I told them that we would not support it. I had a MS KB article that talked about it, but I cannot locate it at this time. With the speed of that WAN, you may not have problems. And since they are willing to test first... Bobby Bobby -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Monday, March 07, 2005 1:55 PM To: 'Discussion of Hardware and Software issues' Subject: RE: [dba-Tech] Access Performance on a WAN Bobby - what is latency? And it will be agreed to by me and my customer before we start. They said they can set up a test to simulate typical activities to see how it goes. Dan -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Bobby Heid Sent: Monday, March 07, 2005 12:19 PM To: 'Discussion of Hardware and Software issues' Subject: RE: [dba-Tech] Access Performance on a WAN >From my understanding, you will do this at your own risk. The speed is >not the issue, it is the latency. Some people have implemented this without any problems, but I have read of others with lots of corruption and the like. Bobby -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Monday, March 07, 2005 12:52 PM To: 'Discussion of Hardware and Software issues' Subject: [dba-Tech] Access Performance on a WAN Hello to Everyone! I have a potential customer with a few different sites around the country. They have a WAN with 1.5 Gbit/sec capacity. I said that I would like to do a test to see if this is feasible with Access XP, and they are willing to do that. I can do a few things to minimize network traffic to help things work faster, but a test is still needed. I do use a split FE/BE setup. Does anyone have experience with this scenario? Does 1.5 Gbit/sec correspond to 1.5 / 8 = 187.5 Mbytes/sec? Thanks! Dan Waters ProMation Systems _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com