Benchmark: Fly Json ODM - 1.19.0 - Query Performance

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();

Rendered benchmark preparation results:

Suite status: <idle, ready to run>

Previous results

Test case name	Result
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.

Fastest: N/A

Slowest: N/A

ⓘ Get performance results from real users on your website with Request Metrics.

Website Performance Monitoring by Request Metrics

Latest run results:

Run details: (Test run date: 9 months ago)

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

Browser/OS: Firefox 116 on Ubuntu

View result in a separate tab

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

Fly Json ODM - 1.19.0 - Query Performance (version: 0)

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

Comparing performance of: Where is the last user. vs Where + Show 10 users with id above than 999990. vs Show All Data but Limit to 10. vs Get 10 last data. vs Paginate data to 10 item per page.

Created: 9 months ago by: Registered User

Jump to the latest result

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.

Suite status: <idle, ready to run>

Experimental features:

Fastest: N/A

Slowest: N/A