At 7/31/12 11:37 AM, MikeyS9607 wrote:
I don't understand from a programming point of view, like when you use an insert query in MySQL, does the server not pick it up till later?
it's a client -> server relation. Think of it as kinda like latency in a game. Latency could be caused by the server just not knowing that the packet was sent to it (CPU overload, not enough RAM, etc)
Usually a restart solves most server problems. Problem is, with large websites restarts are either impossible or near-impossible. Time is money. (Imagine if google went down for a day to restart their servers. Chaos!)
you won't understand it from a programming point of view because in all laws of programming, latency shouldn't exist. It's a networking thing :P