Benchmark: Fly Json ODM - 1.18.2 - Query Performance

HTML Preparation code:

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

Autogenerated LLM Summary (model llama3.2:3b, generated one month ago):

LLMs can make mistakes. Check important info.

I'd be happy to explain what's being tested in this benchmark and the different approaches compared.

**What is being tested?**

This benchmark tests the performance of Fly Json ODM (Object Data Modeling) library in JavaScript, specifically its query methods: `where`, `take`, `orderBy`, and `paginate`. The tests cover various use cases, including:

1. Retrieving a specific user by ID (`Where is the last user.`)
2. Filtering users by ID range (`Where + Show 10 users with id above than 999990.`)
3. Limiting the number of results (`Show All Data but Limit to 10.`)
4. Ordering and limiting the results by ID (`Get 10 last data.`)
5. Paginating the results (`Paginate data to 10 item per page.`)

**Options compared**

The benchmark compares different approaches for each query method:

1. `where`:
	* No filtering condition (i.e., no condition at all) vs.
	* Filtering by ID range (`id > 999990`)
2. `take`:
	* No limit on the number of results vs.
	* Limiting to 10 results
3. `orderBy`:
	* No ordering vs.
	* Ordering by ID in ascending or descending order
4. `paginate`:
	* No pagination vs.
	* Paginating to 10 items per page

**Pros and cons of each approach**

Here's a brief summary of the pros and cons of each approach:

1. `where`:
	* Pros: Faster execution when no filtering condition is applied
	* Cons: Slower execution when filtering conditions are applied
2. `take`:
	* Pros: Better performance when limiting results to a small number
	* Cons: May lead to unnecessary computations if the limit is set too high
3. `orderBy`:
	* Pros: Can improve performance for large datasets when ordering and sorting
	* Cons: May lead to slower execution times due to additional computation
4. `paginate`:
	* Pros: Useful for handling large datasets with a fixed number of items per page
	* Cons: May lead to slower execution times due to pagination overhead

**Fly Json ODM library**

The Fly Json ODM library is a JavaScript library for data modeling and query operations on JSON data. It provides methods like `where`, `take`, `orderBy`, and `paginate` to filter, limit, and sort data.

**Special JS feature or syntax (not applicable in this case)**

There are no special JS features or syntax used in this benchmark that would require additional explanation.

**Alternative approaches**

Other alternatives for query libraries include:

1. MongoDB Node.js driver
2. PostgreSQL driver
3. Express.js middleware-based queries
4. Custom query logic using plain JavaScript arrays and loops.

However, it's essential to note that each of these alternatives has its own strengths and weaknesses, and the choice of library or approach depends on the specific use case, dataset size, and performance requirements.

In summary, this benchmark provides a comprehensive comparison of different query approaches using Fly Json ODM library, allowing users to evaluate the performance and trade-offs of each method for various use cases.

Latest run results:

Run details: (Test run date: one year 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.	1583857.2 Ops/sec
Where + Show 10 users with id above than 999990.	405785.2 Ops/sec
Show All Data but Limit to 10.	12675465.0 Ops/sec
Get 10 last data.	889124.8 Ops/sec
Paginate data to 10 item per page.	3025948.0 Ops/sec

Related benchmarks:

Fly Json ODM - 1.18.2 - Query Performance (version: 1)

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: one year 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

Autogenerated LLM Summary (model llama3.2:3b, generated one month ago):