test-execute-and-unprepare.js 520 B

12345678910111213141516171819202122
  1. var common = require('../../common');
  2. var connection = common.createConnection();
  3. var assert = require('assert');
  4. var max = 500;
  5. var start = process.hrtime();
  6. function exec(i) {
  7. var query = 'select 1+' + i;
  8. connection.execute(query, function(err, rows, columns) {
  9. connection.unprepare(query);
  10. if (err) throw err;
  11. if (i > max)
  12. connection.end();
  13. else
  14. exec(i+1);
  15. });
  16. }
  17. connection.query('SET GLOBAL max_prepared_stmt_count=10', function(err) {
  18. if (err) throw err;
  19. exec(1);
  20. });