forked from CartoDB/node-postgres
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathjs-versus-native-bench.js
More file actions
68 lines (65 loc) · 1.95 KB
/
js-versus-native-bench.js
File metadata and controls
68 lines (65 loc) · 1.95 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
var pg = require(__dirname + '/../lib')
var pgNative = require(__dirname + '/../lib/native');
var bencher = require('bencher');
var helper = require(__dirname + '/../test/test-helper')
var conString = helper.connectionString()
var round = function(num) {
return Math.round((num*1000))/1000
}
var doBenchmark = function() {
var bench = bencher({
name: 'js/native compare',
repeat: 1000,
actions: [{
name: 'javascript client - simple query',
run: function(next) {
var query = client.query('SELECT name, age FROM person WHERE age > 10');
query.on('end', function() {
next();
});
}
},{
name: 'native client - simple query',
run: function(next) {
var query = nativeClient.query('SELECT name FROM person WHERE age > $1', [10]);
query.on('end', function() {
next();
});
}
}, {
name: 'javascript client - parameterized query',
run: function(next) {
var query = client.query('SELECT name, age FROM person WHERE age > $1', [10]);
query.on('end', function() {
next();
});
}
},{
name: 'native client - parameterized query',
run: function(next) {
var query = nativeClient.query('SELECT name, age FROM person WHERE age > $1', [10]);
query.on('end', function() {
next();
});
}
}]
});
bench(function(result) {
console.log();
console.log("%s (%d repeats):", result.name, result.repeat)
result.actions.forEach(function(action) {
console.log(" %s: \n average: %d ms\n total: %d ms", action.name, round(action.meanTime), round(action.totalTime));
})
client.end();
nativeClient.end();
})
}
var client = new pg.Client(conString);
var nativeClient = new pgNative.Client(conString);
client.connect();
client.on('connect', function() {
nativeClient.connect();
nativeClient.on('connect', function() {
doBenchmark();
});
});