Skip to content

Instantly share code, notes, and snippets.

@qix
Created April 1, 2015 18:20
Show Gist options
  • Save qix/8daf3affc16c92abcddb to your computer and use it in GitHub Desktop.
Save qix/8daf3affc16c92abcddb to your computer and use it in GitHub Desktop.
Pipelined queries
#!/usr/bin/env node
'use strict';
var mysql = require('mysql2');
var connection = mysql.createConnection({ user: 'root', database: 'memsql'});
var request = 0;
setInterval(function() {
var thisRequest = 'Request #' + (request++);
console.time(thisRequest);
connection.query('SELECT 1', function(err, rows) {
console.timeEnd(thisRequest);
});
}, 10);
@qix
Copy link
Author

qix commented Apr 1, 2015

$ docker exec dev-memsql 'tc qdisc del dev eth0 root netem'
$ node test.js 
Request #0: 3ms
Request #1: 1ms
Request #2: 0ms
Request #3: 1ms
Request #4: 0ms
Request #5: 1ms
Request #6: 1ms
Request #7: 0ms
Request #8: 0ms
Request #9: 1ms
Request #10: 0ms
Request #11: 0ms
Request #12: 1ms
Request #13: 0ms
Request #14: 1ms
Request #15: 0ms
Request #16: 0ms
Request #17: 1ms
Request #18: 0ms
Request #19: 0ms
Request #20: 0ms

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment