3_TransactionRead.js

(function(s) {
	s['Transaction based on Read'] = {
		category: 'Transaction',
		desc: 'Should read requests be queued in a single transaction, or will it be faster to open multiple transactions and read in batches',
		_bTestKey: 'agt1YS1wcm9maWxlcnINCxIEVGVzdBjIjagUDA',
		onStart: function(cb, status) {
			$.indexedDB('IndexedDBPerf').deleteDatabase().done(function() {
				$.indexedDB('IndexedDBPerf', {
					'schema': {
						'1': function(trans) {
							trans.createObjectStore('Table1', {
								'autoIncrement': true
							});
						}
					}
				}).done(function() {
					var objStore = $.indexedDB('IndexedDBPerf').objectStore('Table1');
					var added = 0;
					for (var i = 0; i < 1000; i++) {
						objStore.add(Faker.Helpers.createCard()).always(function() {
							if (++added >= 999) {
								cb();
							}
							status();
						});
					}
				});
			});
		},
		setup: function() {
			var data = Faker.Helpers.createCard();
		},
		teardown: function() {

		},
		tests: {
			'All Reads in One Transaction': function(deferred) {
				var req = window.indexedDB.open('IndexedDBPerf');
				var readCount = 0;
				req.onsuccess = function() {
					var db = req.result;
					var transaction = db.transaction(['Table1'], 'readonly');
					var objStore = transaction.objectStore('Table1');
					for (var i = 0; i < 1000; i++) {
						(function(i) {
							var readReq = objStore.get(i);
							readReq.onsuccess = readReq.onerror = function() {
								if (++readCount >= 999) {
									db.close()
									deferred.resolve();
								}
							}
						}(i));
					}

				};
				req.onerror = function() {
					throw "Could not open database";
				}
			},
			'Group reads in transaction sets with 10 reads each': function(deferred) {
				var req = window.indexedDB.open('IndexedDBPerf');
				var readCount = 0;
				req.onsuccess = function() {
					var db = req.result;
					//console.log("Database opened");
					for (var i = 0; i < 10; i++) {
						var transaction = db.transaction(['Table1'], 'readonly');
						var objStore = transaction.objectStore('Table1');
						for (var j = 0; j < 100; j++) {
							(function(i) {
								var readReq = objStore.get(i);
								readReq.onsuccess = readReq.onerror = function() {
									if (++readCount >= 999) {
										db.close();
										deferred.resolve();
									}
								}
							}(i));
						}

					}
				};
				req.onerror = function() {
					throw "Could not open database";
				}
			},
			'Each read in its own transaction': function(deferred) {
				var req = window.indexedDB.open('IndexedDBPerf');
				var readCount = 0;
				req.onsuccess = function() {
					var db = req.result;
					//console.log("Database opened");
					for (var i = 0; i < 1000; i++) {
						(function(i) {
							var transaction = db.transaction(['Table1'], 'readonly');
							var objStore = transaction.objectStore('Table1');
							//console.log('Multiple transactions - Reading ', i)
							var readReq = objStore.get(i);
							readReq.onsuccess = readReq.onerror = function() {
								if (++readCount >= 999) {
									db.close();
									deferred.resolve();
								}
							}
						}(i));
					}
				};
				req.onerror = function() {
					throw "Could not open database";
				}
			}
		}
	};
}(window.IndexedDBPerf.suites));