Benchmark: Fly Json ODM - 1.21.0 - Query Performance

HTML Preparation code:

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

Latest run results:

No previous run results

This benchmark does not have any results yet. Be the first one to run it!

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

LLMs can make mistakes. Check important info.

I'll dive right into explaining the benchmark.

**Overview**

The provided benchmark measures the performance of Fly Json ODM, a JavaScript library for NoSQL data storage and query execution. The benchmark tests various query operations on a dataset with 1 million entries.

**Query Operations Compared**

The benchmark compares the performance of five different query operations:

1. `where` (e.g., `query1.where('id',1000000).exec();`)
2. `where` with an inequality condition (`>`)
3. `take` (e.g., `query3.take(10).exec();`) to limit the number of results
4. `orderBy` and `take` together (e.g., `query4.orderBy('id', true).take(10).exec();`)
5. `paginate` (e.g., `query5.paginate(1, 10).exec();`) to paginate data

**Pros and Cons of Each Approach**

Here's a brief overview of each query operation:

* `where`: Simple queries that filter data based on a condition. Pros: efficient for small datasets or specific filtering needs. Cons: may not be optimized for large datasets.
* `where` with inequality: Similar to the previous, but allows for range-based filtering. Pros: useful for finding values above/below a threshold. Cons: still may not be optimized for very large datasets.
* `take`: Used to limit the number of results returned. Pros: can reduce data transfer size and improve performance for smaller result sets. Cons: may lead to slower queries if too many results are requested.
* `orderBy` and `take`: Combines sorting and limiting results, which can be useful for fetching recent or most important data. Pros: can provide more meaningful results with less data transfer. Cons: requires additional processing time.
* `paginate`: Used to divide the dataset into smaller chunks (pages) based on a specified size. Pros: allows for flexible data pagination without loading entire datasets at once. Cons: may impact performance if too many pages are requested.

**Library and Purpose**

Fly Json ODM is a JavaScript library designed for NoSQL data storage and query execution. Its primary purpose is to provide an efficient, lightweight way to store and retrieve data from NoSQL databases in web applications.

**Special JS Features or Syntax**

There's no specific mention of special JavaScript features or syntax in the benchmark. However, it's worth noting that Fly Json ODM likely utilizes some modern JavaScript features, such as async/await or promises, for its query execution logic.

**Alternatives**

If you're looking for alternative NoSQL data storage and query libraries for JavaScript, consider:

* MongoDB Node.js Driver
* Couchbase Lite
* ArangoDB Node.js Driver
* AWS DocumentDB

Keep in mind that each library has its strengths and weaknesses, and the choice ultimately depends on your project's specific needs.

I hope this explanation helps you understand the benchmark!

Related benchmarks:

Fly Json ODM - 1.21.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: 2 years 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>

Fastest: N/A

Slowest: N/A

No previous run results

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