High concurrency for master and high reading from slave slowing down insert - Page 2

@rproffitt what kind of issue will I ran into. Basically I am going to have multiple communication server not just one single server to handle the whole tcp connection. How will that be helpful e.g. each server only server up to 5K devices. So I am not sure what type of hardware specs is needed. I want to know roughly on this and also bandwidth. These are the things I am on the look out now.

@n. I can't tell you since it's been a few years since we went to press. Maybe the mobile carriers got better.

Remember I defered to priors about thousands of connections in Java. https://www.google.com/search?q=thousands+of+tcp+connections+in+java

I'm not going to rehash priors and discuss with you areas I'd worry about.

@rproffitt well based on the googling result I think best is to break it down to multiple server right. So any other tips you would like to add on ?

Just one thing. Be sure to put the devices into every car you can and test as long as you can. I've lost count of efforts like this where they try to design it but forget the real world testing. That's where the TCP method should show breakage if there's a problem there.

Still wonder why you went down that road since it tends to be costly. That is, if you are competing with another company they would have a price advantage.

@rproffitt I mean we want to do some kind of simulation to try to understand the actual situation. We dont want to be caught up with the real situation and think that moment is bad. I dont get you here "Still wonder why you went down that road since it tends to be costly. That is, if you are competing with another company they would have a price advantage" Which road mean ? I dotn get you here?

@n. Simulation will not reveal the issue I noted about TCP, cellular carriers and transitions from tower to tower. Only your newest of the new would think simulation will reveal that issue.

Another area simulation won't uncover is the data use and charges.

As to road, I've written enough on the direction your designer took. That's the road. I fear you won't learn except by experiencing the issues first hand. That's OK. And how most folk learn this system.

@rptoffitt ok will try to learn and adapt as much as you have suggested here. Hopefully its helpful.