Hi all, Thanks for the responses. On Thursday 27 May 2010 15:13:50 Joseph Gwinn wrote: > In article <201005271035.46352.fmgrotep...@yahoo.co.uk>, > > Frans Grotepass <fmgrotep...@yahoo.co.uk> wrote: > > Hi all, > > > > Sorry for abusing my membership to this forum for this question. > > > > We are busy with building an embedded application that must retrieve data > > very fast. > > Please define "very fast" in numbers. For example, 95% of responses must > be fully received within 1,000 microseconds, and 100% within 10 > milliseconds, or the planet will explode.
This matches the specs. > What does the embedded application do? > SMS-routing > > The choice is to either have the data locally or go to a central > > server(pool) that contains the data. > > Well, locally is always faster and more predictable than remotely, so why > even consider remotely? The problem is that the remote db is already available and this will mean replicating the remote db locally. The remote db has all the data in memory. The local response time must be so fast that one needs a db solution with all the data in memory, otherwise the disk seek time will kill us. > > In evaluating the network option, I thought that the people here could > > possibly help me with the expected network latency for a Gb network via a > > switch. My gut feeling says that with increased load, the switch will > > bundle the traffic to the different nodes more and this will result in > > higher latency. > > Big switches can have transit latencies of a few tens of microseconds, but > there is far more to it than that. And if there is a choke point > somewhere, the observed latencey will vary wildly depending on perhaps > unrelated traffic and loading, making it appear that the latency varies > randomly. The farther the commands and resulting data travel, the more > vulnerable one is to these effects. These delays (even with local network) will make the solution impossible. Sorry again for posing the questions here. I know this is a blatant off topic post, but getting the details from the internet is a little more difficult and there are so many people here with the knowledge at hand. Thanks for the help. _______________________________________________ questions mailing list questions@lists.ntp.org http://lists.ntp.org/listinfo/questions
