Alasql.js vs WebSQL (v9)

Revision 9 of this benchmark created by Meraj on September 30, 2015

Description

Preparation HTML

<script src="https://raw.githubusercontent.com/agershun/alasql/develop/dist/alasql.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';

</script>

Test runner

// async test
// 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(query, [], function() {
    deferred.resolve();
  });
});

var adb = new alasql.Database();
sqls.forEach(function(sql) {
  adb.exec(sql);
});
adb.exec(query);

Revisions

You can edit these tests or add more tests to this page by appending /edit to the URL.

• Revision 1: published by Andrey Gershun on November 5, 2014
• Revision 2: published on November 7, 2014
• Revision 3: published by Dre Headphones on December 12, 2014
• Revision 4: published by Peluang Usaha Yang Menjanjikan Ibu Rumah Tangga on December 16, 2014
• Revision 5: published by agershun on January 26, 2015
• Revision 6: published on January 26, 2015
• Revision 7: published by agershun on January 26, 2015
• Revision 8: published by mathiasrw on September 25, 2015
• Revision 9: published by Meraj on September 30, 2015