Info

Index performance test for https://github.com/vshjxyz/Indexed-localStorageDB to compare the speed with/without indexes

Preparation code

<script src="https://raw.github.com/vshjxyz/Indexed-localStorageDB/master/localstoragedb.js">
</script>
<script>
  Benchmark.prototype.setup = function() {
    var lib = new localStorageDB("library");
    var index_lib = new localStorageDB("library_indexed");
    if (lib.isNew()) {
    
      lib.createTable("books", ["id", "title", "author", "year", "copies"]);
    
      for (var i = 0; i < 15000; i++) {
        lib.insert("books", {
          id: "B00" + i,
          title: "Phantoms in the brain " + i,
          author: "Ramachandran",
          year: (1999 + i),
          copies: (10 + i)
        });
      }
    
      lib.commit();
    }
    
    if (index_lib.isNew()) {
    
      index_lib.createTable("books", ["id", "title", "author", "year", "copies"], ["id", "year"]);
    
      for (var i = 0; i < 15000; i++) {
        index_lib.insert("books", {
          id: "B00" + i,
          title: "Phantoms in the brain " + i,
          author: "Ramachandran",
          year: (1999 + i),
          copies: (10 + i)
        });
      }
    
      index_lib.commit();
    }
  };

  Benchmark.prototype.teardown = function() {
    lib.drop();
    lib.commit();
    
    index_lib.drop();
    index_lib.commit();
  };
</script>

Test runner

Warning! For accurate results, please disable Firebug before running the tests. (Why?)

Java applet disabled.

lib.insert("books", {
  id: "XXX",
  title: "Phantoms in the brain",
  author: "Ramachandran",
  year: 1999,
  copies: 10
});
lib.commit();

lib.insert("books", {
  id: "XXX",
  title: "Phantoms in the brain",
  author: "Ramachandran",
  year: 1999,
  copies: 10
});
lib.commit();

Compare results of other browsers

Revisions

You can edit these tests or add even more tests to this page by appending /edit to the URL. Here’s a list of current revisions for this page:

• Revision 1: published by VSHJXYZ on 6th August 2012
• Revision 2: published by VSHJXYZ on 8th August 2012
• Revision 4: published on 28th January 2013
• Revision 10: published on 15th February 2013

0 comments