Run results for: Fly Json ODM - 1.19.0 - Query Performance

Run details:

User agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/116.0

Browser: Firefox 116

Operating system: Ubuntu

Device Platform: Desktop

Date tested: one year ago

Test name	Executions per second
Where is the last user.	1470977.6 Ops/sec
Where + Show 10 users with id above than 999990.	405135.6 Ops/sec
Show All Data but Limit to 10.	12619809.0 Ops/sec
Get 10 last data.	823267.3 Ops/sec
Paginate data to 10 item per page.	2902703.0 Ops/sec

HTML Preparation code:

<script src="https://cdn.jsdelivr.net/npm/fly-json-odm@1.19.0/dist/flyjson.min.js"></script>

Script Preparation code:

var data = [];

var start = 1;
var end = 1000000;

// Build datatable
for(var i =start;i<=end;i++) {
  data.push({ id:i, name:'user_'+i });
}

// Set Datatable
var nosql1 = new FlyJson();
var query1 = nosql1.set(data);

var nosql2 = new FlyJson();
var query2 = nosql2.set(data);

var nosql3 = new FlyJson();
var query3 = nosql3.set(data);

var nosql4 = new FlyJson();
var query4 = nosql4.set(data);

var nosql5 = new FlyJson();
var query5 = nosql5.set(data);

Tests:

Where is the last user.
var result = query1.where('id',1000000).exec();
Where + Show 10 users with id above than 999990.
var result = query2.where('id', '>',999990).exec();
Show All Data but Limit to 10.
var result = query3.take(10).exec();
Get 10 last data.
var result = query4.orderBy('id', true).take(10).exec();
Paginate data to 10 item per page.
var result = query5.paginate(1, 10).exec();

Run results for: Fly Json ODM - 1.19.0 - Query Performance

Benchmark using Fly Json ODM in browser for most common queries only.

Where is the last user.

Where + Show 10 users with id above than 999990.

Show All Data but Limit to 10.

Get 10 last data.

Paginate data to 10 item per page.