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

Run details:

User agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36

Browser: Chrome 117

Operating system: Mac OS X 10.15.7

Device Platform: Desktop

Date tested: one year ago

Test name	Executions per second
Where is the last user.	11744587.0 Ops/sec
Where + Show 10 users with id above than 999990.	3492907.8 Ops/sec
Show All Data but Limit to 10.	30518312.0 Ops/sec
Get 10 last data.	4976903.5 Ops/sec
Paginate data to 10 item per page.	17259116.0 Ops/sec

HTML Preparation code:

<script src="https://cdn.jsdelivr.net/npm/fly-json-odm@1.20.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.20.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.