benchmark-query.js 967 B

1234567891011121314151617181920212223242526272829303132333435
  1. var assert = require('assert');
  2. var createConnection = require('../test/common').createConnection;
  3. var sql = process.argv[2];
  4. (function(cb) {
  5. var db = createConnection();
  6. var left = 10000;
  7. var start = Date.now();
  8. var prev1000 = start;
  9. function bench()
  10. {
  11. db.query(sql).on('end', function(err, res) {
  12. left--;
  13. if (left % 1000 === 0)
  14. {
  15. var curTime = Date.now();
  16. var last1000time = curTime - prev1000;
  17. prev1000 = curTime;
  18. console.error( (1000000/last1000time) + ' req/sec' );
  19. }
  20. if (left > 0)
  21. bench();
  22. else {
  23. console.error( 10000000/(Date.now() - start) + ' req/sec (average 10000 reqs)');
  24. db.end();
  25. if (cb) cb();
  26. }
  27. });
  28. }
  29. bench();
  30. })();