Use INSERT ... ON DUPLICATE KEY UPDATE
Query:
INSERT INTO table (id, name, age) VALUES(1, "A", 19) ON DUPLICATE KEY UPDATE name = "A", age = 19Install apache2-utils
$ sudo apt-get install apache2-utilsExample test:
$ ab -kc 1000 -n 10000 http://www.some-site.cc/tmp/index.phpk Use HTTP KeepAlive feature c concurrency Number of multiple requests to make at a time n requests Number of requests to performOur JavaScript function is far more precise about what kinds of data can be considered empty:
undefined or nullfunction isEmpty(data) {
if (typeof(data) == 'number' || typeof(data) == 'boolean') {
return false;
}
if (typeof(data) == 'undefined' || data === null) {
return true;
}
if (typeof(data.length) != 'undefined') {
return data.length === 0;
}
var count = 0, i;
for (i in data) {
if(data.hasOwnProperty(i)) {
count ++;
}
}
return count === 0;
}