jsPerf.app is an online JavaScript performance benchmark test runner & jsperf.com mirror. It is a complete rewrite in homage to the once excellent jsperf.com now with hopefully a more modern & maintainable codebase.
jsperf.com URLs are mirrored at the same path, e.g:
https://jsperf.com/negative-modulo/2
Can be accessed at:
https://jsperf.app/negative-modulo/2
Compare two browser databases Alasql (https://github.com/agershun/alasql) and WebSQL.
<script src="http://alasql.org/console/alasql.min.js"></script>
<script>
var NUM_TESTS = 1000;
// Generate SQL statements
var sqls = [
'DROP TABLE IF EXISTS test1',
'DROP TABLE IF EXISTS test2',
'CREATE TABLE test1 (one INT, two INT)',
'CREATE TABLE test2 (two INT, three INT)',
];
for (var i = 0; i < NUM_TESTS; i++) {
sqls.push('INSERT INTO test1 VALUES (' + i % 10 + ',' + ((i * i) % 10) + ')');
sqls.push('INSERT INTO test2 VALUES (' + i % 10 + ',' + ((i * i) % 10) + ')');
}
// Complex query
var query = 'SELECT SUM(test1.one) AS sumone, test1.two, test2.three FROM test1 JOIN test2 ON test1.two = test2.two WHERE test1.one > 5 GROUP BY test1.two, test2.three ORDER BY three, sumone';
// Prepare WebSQL.JS database
var wdb = openDatabase('wdb', '0.1', 'Test database', 1000000);
wdb.transaction(function(tx) {
sqls.forEach(function(sql) {
tx.executeSql(sql);
});
tx.executeSql('CREATE INDEX a ON test1(two)');
tx.executeSql('CREATE INDEX b ON test2(two)');
});
var adb = new alasql.Database();
sqls.forEach(function(sql) {
adb.exec(sql);
});
</script>
Ready to run.
Test | Ops/sec | |
---|---|---|
WebSQL |
| ready |
Alasql |
| ready |
Alasql without cache |
| ready |
You can edit these tests or add more tests to this page by appending /edit to the URL.