Benchmark: Fly Json ODM - 1.20.0 - Query Performance

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

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.

MeasureThat.net is a website that allows users to create and run JavaScript microbenchmarks, providing insights into the performance of different approaches.

The benchmark being tested measures the query performance of Fly Json ODM (Object Data Modeling), a library used for storing and querying data in JavaScript. The test cases compare various options used in queries, such as:

1. **Where clause**: Filtering data by a specific condition.
2. **Sorting and limiting**: Sorting and limiting the number of results returned.
3. **Pagination**: Dividing data into pages with a specified size.

Here's an explanation of each option, its pros and cons, and other considerations:

**Where clause**

* Description: Filtering data by a specific condition (e.g., `id` > 999990).
* Pros:
	+ Efficient way to filter large datasets.
	+ Reduces the amount of data that needs to be processed.
* Cons:
	+ May slow down queries for smaller datasets or if the condition is complex.
* Consideration: The "Where" clause can be useful when filtering out unnecessary data, but it may not be suitable for all use cases.

**Sorting and limiting**

* Description: Sorting data by a specific field and limiting the number of results returned (e.g., `take(10)`).
* Pros:
	+ Helps with data analysis and visualization.
	+ Reduces the amount of data that needs to be processed.
* Cons:
	+ May slow down queries for large datasets or if the sorting order is complex.
* Consideration: Sorting and limiting can be useful when working with large datasets, but it may not be suitable for all use cases.

**Pagination**

* Description: Dividing data into pages with a specified size (e.g., `paginate(1, 10)`).
* Pros:
	+ Helps with data pagination and navigation.
	+ Reduces the amount of data that needs to be processed.
* Cons:
	+ May slow down queries for large datasets or if the page size is too small.
* Consideration: Pagination can be useful when working with large datasets, but it may not be suitable for all use cases.

The Fly Json ODM library used in this benchmark provides a simple and efficient way to store and query data. However, its performance may vary depending on the specific queries and dataset sizes.

Other alternatives that could be considered for similar use cases include:

* MongoDB (a popular NoSQL database)
* PostgreSQL (a popular relational database)
* Firebase Realtime Database or Cloud Firestore (real-time NoSQL databases)

These alternatives may offer different trade-offs in terms of performance, scalability, and ease of use.

Latest run results:

Run details: (Test run date: one year ago)

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/OS: Chrome 117 on Mac OS X 10.15.7

View result in a separate tab

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

Related benchmarks:

Fly Json ODM - 1.20.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: 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):