Benchmark on 1vCPU - 1.5GB Server

[CovertCode]

Server config:

1.5 GB Ryzen 7950X VPS
1 vCPU AMD Ryzen 7950X Core
30 GB Gen4 NVMe Storage
1.5 GB DDR5 RAM

I used benchmark repo provided by @ganigeorgiev without any modifications.
https://github.com/pocketbase/benchmarks/tree/master
You can compare tests from this: https://github.com/pocketbase/benchmarks/blob/master/results/hetzner_cax11.md

While this test was running on my server there were 2 nodejs backends + mongodb instance running.

Memory usage never went above 500MB of the entire server.

@ganigeorgiev would like to have your input on the comparison.

Benchmark:

Creating organizations (100)

Creating 50 organizations [reqs:50, conc:10, rule:""]

┌─ Best:      4.489927ms
├─ Worst:     35.340417ms
├─ Completed: 79.543376ms
└─ Errors:    0

Creating 50 organizations [reqs:50, conc:10, rule:"@request.data.name != ''"]

┌─ Best:      2.815633ms
├─ Worst:     18.502391ms
├─ Completed: 48.373485ms
└─ Errors:    0

Creating permissions (50)

Creating 25 permissions [reqs:25, conc:5, rule:""]

┌─ Best:      3.63135ms
├─ Worst:     11.08821ms
├─ Completed: 37.571715ms
└─ Errors:    0

Creating 25 permissions [reqs:25, conc:5, rule:"@request.data.name != ''"]

┌─ Best:      3.68643ms
├─ Worst:     16.131481ms
├─ Completed: 48.794878ms
└─ Errors:    0

Creating users (500 - expected to be slow due to passwordHash generation)

Creating 250 users [reqs:250, conc:50, rule:""]

┌─ Best:      14.703779666s
├─ Worst:     19.461841864s
├─ Completed: 1m27.503586966s
└─ Errors:    0

Creating 250 users [reqs:250, conc:50, rule:"@request.data.email != '' && @request.data.permissions:length > 0"]

┌─ Best:      11.44590344s
├─ Worst:     19.467208823s
├─ Completed: 1m25.719516094s
└─ Errors:    0

Creating posts (10k, 25k, 50k, 100k)

Creating 5000 posts10k [reqs:5000, conc:500, rule:""]

┌─ Best:      188.084498ms
├─ Worst:     2.953447948s
├─ Completed: 9.297139302s
└─ Errors:    0

Creating 5000 posts10k [reqs:5000, conc:500, rule:"@request.auth.id != '' && @request.data.public:isset = true"]

┌─ Best:      190.171584ms
├─ Worst:     3.695154023s
├─ Completed: 12.085916891s
└─ Errors:    0

Creating 12500 posts25k [reqs:12500, conc:500, rule:""]

┌─ Best:      159.149303ms
├─ Worst:     2.790024331s
├─ Completed: 23.510026083s
└─ Errors:    0

Creating 12500 posts25k [reqs:12500, conc:500, rule:"@request.auth.id != '' && @request.data.public:isset = true"]

┌─ Best:      92.638662ms
├─ Worst:     3.957650513s
├─ Completed: 30.16946362s
└─ Errors:    0

Creating 25000 posts50k [reqs:25000, conc:500, rule:""]

┌─ Best:      138.367013ms
├─ Worst:     3.215939535s
├─ Completed: 49.406405337s
└─ Errors:    0

Creating 25000 posts50k [reqs:25000, conc:500, rule:"@request.auth.id != '' && @request.data.public:isset = true"]

┌─ Best:      158.036473ms
├─ Worst:     3.954165454s
├─ Completed: 59.673330726s
└─ Errors:    0

Creating 50000 posts100k [reqs:50000, conc:500, rule:""]

┌─ Best:      148.325533ms
├─ Worst:     3.109604374s
├─ Completed: 1m37.638340171s
└─ Errors:    0

Creating 50000 posts100k [reqs:50000, conc:500, rule:"@request.auth.id != '' && @request.data.public:isset = true"]

┌─ Best:      96.622524ms
├─ Worst:     3.748083568s
├─ Completed: 1m57.882954376s
└─ Errors:    0

User auth with password (expected to be slow due to passwordHash verification)

users auth with email/pass - high concurrency [reqs:250, conc:250]

┌─ Best:      39.623928647s
├─ Worst:     43.857907751s
├─ Completed: 43.86247814s
└─ Errors:    0

users auth with email/pass - small concurrency [reqs:250, conc:10]

┌─ Best:      815.801239ms
├─ Worst:     3.290479977s
├─ Completed: 45.525105509s
└─ Errors:    0

User auth refresh

users - auth refresh (high concurrency) [reqs:1000, conc:1000]

┌─ Best:      158.472416ms
├─ Worst:     882.970803ms
├─ Completed: 888.481568ms
└─ Errors:    0

users - auth refresh (medium concurrency) [reqs:1000, conc:100]

┌─ Best:      21.244822ms
├─ Worst:     197.861875ms
├─ Completed: 879.466785ms
└─ Errors:    0

List records

users - getOne for auth refresh comparison (high concurrency) [reqs:1000, conc:1000, rule:"", query:/aqf4u4tf8xat5vg]

┌─ Best:      262.663111ms
├─ Worst:     1.117639757s
├─ Completed: 1.130897326s
└─ Errors:    0

users - getOne for auth refresh comparison (medium concurrency) [reqs:1000, conc:100, rule:"", query:/aqf4u4tf8xat5vg]

┌─ Best:      26.431966ms
├─ Worst:     234.166801ms
├─ Completed: 1.026103755s
└─ Errors:    0

posts10k - simpleA (many requests, no rules, no concurrency) [reqs:1000, conc:1, rule:"", query:?perPage=20]

┌─ Best:      1.309411ms
├─ Worst:     10.977169ms
├─ Completed: 2.620890332s
└─ Errors:    0

posts10k - simpleB (many requests, no rules, high concurrency) [reqs:1000, conc:1000, rule:"", query:?perPage=20]

┌─ Best:      334.556294ms
├─ Worst:     2.642164796s
├─ Completed: 2.646825086s
└─ Errors:    0

posts10k - simpleC (many requests, no rules, high concurrency, skipTotal) [reqs:1000, conc:1000, rule:"", query:?perPage=20&skipTotal=1]

┌─ Best:      297.126001ms
├─ Worst:     2.426288554s
├─ Completed: 2.43185478s
└─ Errors:    0

posts10k - mixed read and write (simpleA list with additional 300 concurrent random posts10k updates running in the background) [reqs:1000, conc:1000, rule:"", query:?perPage=20]

┌─ Best:      686.565031ms
├─ Worst:     3.176096677s
├─ Completed: 3.212388961s
└─ Errors:    0

posts10k - expand author [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author]

┌─ Best:      12.739912ms
├─ Worst:     74.780848ms
├─ Completed: 389.67423ms
└─ Errors:    0

posts10k - expand author (limited fields) [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author&fields=id,collectionId,expand.author.id]

┌─ Best:      10.787566ms
├─ Worst:     70.22445ms
├─ Completed: 390.90607ms
└─ Errors:    0

posts10k - expand author.permissions [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author.permissions]

┌─ Best:      24.058905ms
├─ Worst:     133.004678ms
├─ Completed: 568.145329ms
└─ Errors:    0

posts10k - expand author.permissions (limited fields) [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author.permissions&fields=id,collectionId,expand.author.id,expand.author.expand.permissions.id]

┌─ Best:      14.707069ms
├─ Worst:     120.62822ms
├─ Completed: 605.969575ms
└─ Errors:    0

posts10k - simple auth rule [reqs:100, conc:10, rule:"@request.auth.id != ''", query:?perPage=20]

┌─ Best:      4.379246ms
├─ Worst:     59.982926ms
├─ Completed: 283.783922ms
└─ Errors:    0

posts10k - author check (no index) [reqs:100, conc:10, rule:"author = @request.auth.id", query:?perPage=20]

┌─ Best:      33.000207ms
├─ Worst:     183.522307ms
├─ Completed: 1.11560335s
└─ Errors:    0

posts10k - author check (with index) [reqs:100, conc:10, rule:"author = @request.auth.id", query:?perPage=20]

┌─ Best:      7.749333ms
├─ Worst:     25.414946ms
├─ Completed: 146.185686ms
└─ Errors:    0

posts10k - author check (with index and skipTotal) [reqs:100, conc:10, rule:"author = @request.auth.id", query:?perPage=20&skipTotal=1]

┌─ Best:      8.784491ms
├─ Worst:     53.300254ms
├─ Completed: 223.271911ms
└─ Errors:    0

posts10k - author.id (extra join) check (no index) [reqs:100, conc:10, rule:"author.id = @request.auth.id", query:?perPage=20]

┌─ Best:      54.787184ms
├─ Worst:     351.123718ms
├─ Completed: 1.906977643s
└─ Errors:    0

posts10k - author.id (extra join) check (with index) [reqs:100, conc:10, rule:"author.id = @request.auth.id", query:?perPage=20]

┌─ Best:      7.628532ms
├─ Worst:     40.286557ms
├─ Completed: 194.177596ms
└─ Errors:    0

posts10k - author.id (extra join) check (with index and skipTotal) [reqs:100, conc:10, rule:"author.id = @request.auth.id", query:?perPage=20&skipTotal=1]

┌─ Best:      7.182099ms
├─ Worst:     42.587396ms
├─ Completed: 207.163031ms
└─ Errors:    0

posts10k - loose large text search (no index) [reqs:100, conc:10, rule:"description ~ 'ipsum dolor'", query:?perPage=20]

┌─ Best:      23.192428ms
├─ Worst:     180.01463ms
├─ Completed: 884.721899ms
└─ Errors:    0

posts10k - loose large text search (with index) [reqs:100, conc:10, rule:"description ~ 'ipsum dolor'", query:?perPage=20]

┌─ Best:      31.048312ms
├─ Worst:     137.608576ms
├─ Completed: 761.215975ms
└─ Errors:    0

posts10k - loose large text search (with index and skipTotal) [reqs:100, conc:10, rule:"description ~ 'ipsum dolor'", query:?perPage=20&skipTotal=1]

┌─ Best:      19.301147ms
├─ Worst:     131.437807ms
├─ Completed: 712.118107ms
└─ Errors:    0

posts10k - multiple select :each (no index, match-all) [reqs:100, conc:10, rule:"type:each != 'c'", query:?perPage=20]

┌─ Best:      141.785591ms
├─ Worst:     477.06994ms
├─ Completed: 2.950044651s
└─ Errors:    0

posts10k - multiple select :each (no index, match-all, skipTotal) [reqs:100, conc:10, rule:"type:each != 'c'", query:?perPage=20&skipTotal=1]

┌─ Best:      121.758707ms
├─ Worst:     574.544181ms
├─ Completed: 2.945242422s
└─ Errors:    0

posts10k - multiple select :each (no index, at-least-one) [reqs:100, conc:10, rule:"type:each ?!= 'c'", query:?perPage=20]

┌─ Best:      34.827132ms
├─ Worst:     203.890293ms
├─ Completed: 1.099774943s
└─ Errors:    0

posts10k - multiple select :each (no index, at-least-one, skipTotal) [reqs:100, conc:10, rule:"type:each ?!= 'c'", query:?perPage=20&skipTotal=1]

┌─ Best:      32.231102ms
├─ Worst:     221.043762ms
├─ Completed: 1.094696911s
└─ Errors:    0

posts10k - nested single relations lookup (no indexes) [reqs:100, conc:10, rule:"author.organization.name != 'test'", query:?perPage=20]

┌─ Best:      88.382188ms
├─ Worst:     458.245338ms
├─ Completed: 2.699741s
└─ Errors:    0

posts10k - nested single relations lookup (no indexes, skipTotal) [reqs:100, conc:10, rule:"author.organization.name != 'test'", query:?perPage=20&skipTotal=1]

┌─ Best:      54.708704ms
├─ Worst:     498.897808ms
├─ Completed: 2.801380053s
└─ Errors:    0

posts10k - nested multiple relations lookup (no indexes, match-all) [reqs:100, conc:10, rule:"author.permissions.active = true", query:?perPage=20]

┌─ Best:      394.57255ms
├─ Worst:     1.141397018s
├─ Completed: 8.214431811s
└─ Errors:    0

posts10k - nested multiple relations lookup (no indexes, match-all, skipTotal) [reqs:100, conc:10, rule:"author.permissions.active = true", query:?perPage=20&skipTotal=1]

┌─ Best:      431.34406ms
├─ Worst:     1.294191006s
├─ Completed: 7.912339841s
└─ Errors:    0

posts10k - nested multiple relations lookup (no indexes, at-least-one) [reqs:100, conc:10, rule:"author.permissions.active ?= true", query:?perPage=20]

┌─ Best:      957.768796ms
├─ Worst:     2.639166937s
├─ Completed: 20.955959266s
└─ Errors:    0

posts10k - nested multiple relations lookup (no indexes, at-least-one, skipTotal) [reqs:100, conc:10, rule:"author.permissions.active ?= true", query:?perPage=20&skipTotal=1]

┌─ Best:      682.182278ms
├─ Worst:     2.730235005s
├─ Completed: 20.940469873s
└─ Errors:    0

posts25k - simpleA (many requests, no rules, no concurrency) [reqs:1000, conc:1, rule:"", query:?perPage=20]

┌─ Best:      2.839943ms
├─ Worst:     15.662049ms
├─ Completed: 4.270242248s
└─ Errors:    0

posts25k - simpleB (many requests, no rules, high concurrency) [reqs:1000, conc:1000, rule:"", query:?perPage=20]

┌─ Best:      403.239613ms
├─ Worst:     3.952207723s
├─ Completed: 3.953605645s
└─ Errors:    0

posts25k - simpleC (many requests, no rules, high concurrency, skipTotal) [reqs:1000, conc:1000, rule:"", query:?perPage=20&skipTotal=1]

┌─ Best:      544.681252ms
├─ Worst:     3.784331436s
├─ Completed: 3.79340197s
└─ Errors:    0

posts25k - mixed read and write (simpleA list with additional 300 concurrent random posts25k updates running in the background) [reqs:1000, conc:1000, rule:"", query:?perPage=20]

┌─ Best:      389.542771ms
├─ Worst:     4.90907139s
├─ Completed: 4.913403957s
└─ Errors:    0

posts25k - expand author [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author]

┌─ Best:      20.958441ms
├─ Worst:     117.784555ms
├─ Completed: 610.558908ms
└─ Errors:    0

posts25k - expand author (limited fields) [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author&fields=id,collectionId,expand.author.id]

┌─ Best:      23.14485ms
├─ Worst:     118.533051ms
├─ Completed: 562.380006ms
└─ Errors:    0

posts25k - expand author.permissions [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author.permissions]

┌─ Best:      26.201184ms
├─ Worst:     130.239946ms
├─ Completed: 663.329334ms
└─ Errors:    0

posts25k - expand author.permissions (limited fields) [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author.permissions&fields=id,collectionId,expand.author.id,expand.author.expand.permissions.id]

┌─ Best:      34.882475ms
├─ Worst:     136.073293ms
├─ Completed: 733.280905ms
└─ Errors:    0

posts25k - simple auth rule [reqs:100, conc:10, rule:"@request.auth.id != ''", query:?perPage=20]

┌─ Best:      10.367375ms
├─ Worst:     79.828104ms
├─ Completed: 419.787478ms
└─ Errors:    0

posts25k - author check (no index) [reqs:100, conc:10, rule:"author = @request.auth.id", query:?perPage=20]

┌─ Best:      40.107089ms
├─ Worst:     238.805667ms
├─ Completed: 1.449342371s
└─ Errors:    0

posts25k - author check (with index) [reqs:100, conc:10, rule:"author = @request.auth.id", query:?perPage=20]

┌─ Best:      5.356824ms
├─ Worst:     44.040431ms
├─ Completed: 245.088908ms
└─ Errors:    0

posts25k - author check (with index and skipTotal) [reqs:100, conc:10, rule:"author = @request.auth.id", query:?perPage=20&skipTotal=1]

┌─ Best:      5.835138ms
├─ Worst:     37.648647ms
├─ Completed: 169.269566ms
└─ Errors:    0

posts25k - author.id (extra join) check (no index) [reqs:100, conc:10, rule:"author.id = @request.auth.id", query:?perPage=20]

┌─ Best:      107.726462ms
├─ Worst:     673.909896ms
├─ Completed: 3.668495903s
└─ Errors:    0

posts25k - author.id (extra join) check (with index) [reqs:100, conc:10, rule:"author.id = @request.auth.id", query:?perPage=20]

┌─ Best:      3.777092ms
├─ Worst:     54.130033ms
├─ Completed: 245.520162ms
└─ Errors:    0

posts25k - author.id (extra join) check (with index and skipTotal) [reqs:100, conc:10, rule:"author.id = @request.auth.id", query:?perPage=20&skipTotal=1]

┌─ Best:      7.910605ms
├─ Worst:     53.601259ms
├─ Completed: 232.298262ms
└─ Errors:    0

posts25k - loose large text search (no index) [reqs:100, conc:10, rule:"description ~ 'ipsum dolor'", query:?perPage=20]

┌─ Best:      51.203448ms
├─ Worst:     256.824593ms
├─ Completed: 1.665262787s
└─ Errors:    0

posts25k - loose large text search (with index) [reqs:100, conc:10, rule:"description ~ 'ipsum dolor'", query:?perPage=20]

┌─ Best:      63.262948ms
├─ Worst:     233.809294ms
├─ Completed: 1.491122163s
└─ Errors:    0

posts25k - loose large text search (with index and skipTotal) [reqs:100, conc:10, rule:"description ~ 'ipsum dolor'", query:?perPage=20&skipTotal=1]

┌─ Best:      48.75313ms
├─ Worst:     284.511381ms
├─ Completed: 1.490668878s
└─ Errors:    0

posts25k - multiple select :each (no index, match-all) [reqs:100, conc:10, rule:"type:each != 'c'", query:?perPage=20]

┌─ Best:      545.540367ms
├─ Worst:     2.090452058s
├─ Completed: 12.160822132s
└─ Errors:    0

posts25k - multiple select :each (no index, match-all, skipTotal) [reqs:100, conc:10, rule:"type:each != 'c'", query:?perPage=20&skipTotal=1]

┌─ Best:      422.47048ms
├─ Worst:     1.801938416s
├─ Completed: 11.646545276s
└─ Errors:    0

posts25k - multiple select :each (no index, at-least-one) [reqs:100, conc:10, rule:"type:each ?!= 'c'", query:?perPage=20]

┌─ Best:      70.72884ms
├─ Worst:     532.754742ms
├─ Completed: 2.856783545s
└─ Errors:    0

posts25k - multiple select :each (no index, at-least-one, skipTotal) [reqs:100, conc:10, rule:"type:each ?!= 'c'", query:?perPage=20&skipTotal=1]

┌─ Best:      91.464728ms
├─ Worst:     426.975767ms
├─ Completed: 2.599983589s
└─ Errors:    0

posts25k - nested single relations lookup (no indexes) [reqs:100, conc:10, rule:"author.organization.name != 'test'", query:?perPage=20]

┌─ Best:      287.374613ms
├─ Worst:     1.657406533s
├─ Completed: 7.988264883s
└─ Errors:    0

posts25k - nested single relations lookup (no indexes, skipTotal) [reqs:100, conc:10, rule:"author.organization.name != 'test'", query:?perPage=20&skipTotal=1]

┌─ Best:      232.263462ms
├─ Worst:     1.56561399s
├─ Completed: 8.351233683s
└─ Errors:    0

posts25k - nested multiple relations lookup (no indexes, match-all) [reqs:100, conc:10, rule:"author.permissions.active = true", query:?perPage=20]

┌─ Best:      873.559852ms
├─ Worst:     2.654047941s
├─ Completed: 20.944433744s
└─ Errors:    0

posts25k - nested multiple relations lookup (no indexes, match-all, skipTotal) [reqs:100, conc:10, rule:"author.permissions.active = true", query:?perPage=20&skipTotal=1]

┌─ Best:      1.115429812s
├─ Worst:     2.844964184s
├─ Completed: 21.124973443s
└─ Errors:    0

posts25k - nested multiple relations lookup (no indexes, at-least-one) [reqs:100, conc:10, rule:"author.permissions.active ?= true", query:?perPage=20]

┌─ Best:      4.126120756s
├─ Worst:     6.397677854s
├─ Completed: 53.825012529s
└─ Errors:    0

posts25k - nested multiple relations lookup (no indexes, at-least-one, skipTotal) [reqs:100, conc:10, rule:"author.permissions.active ?= true", query:?perPage=20&skipTotal=1]

┌─ Best:      4.221512172s
├─ Worst:     7.323177831s
├─ Completed: 59.366673353s
└─ Errors:    0

posts50k - simpleA (many requests, no rules, no concurrency) [reqs:1000, conc:1, rule:"", query:?perPage=20]

┌─ Best:      5.161461ms
├─ Worst:     30.62238ms
├─ Completed: 8.429625603s
└─ Errors:    0

posts50k - simpleB (many requests, no rules, high concurrency) [reqs:1000, conc:1000, rule:"", query:?perPage=20]

┌─ Best:      1.532817245s
├─ Worst:     8.134660878s
├─ Completed: 8.14335855s
└─ Errors:    0

posts50k - simpleC (many requests, no rules, high concurrency, skipTotal) [reqs:1000, conc:1000, rule:"", query:?perPage=20&skipTotal=1]

┌─ Best:      834.143177ms
├─ Worst:     5.69002766s
├─ Completed: 5.703843021s
└─ Errors:    0

posts50k - mixed read and write (simpleA list with additional 300 concurrent random posts50k updates running in the background) [reqs:1000, conc:1000, rule:"", query:?perPage=20]

┌─ Best:      598.300275ms
├─ Worst:     6.788126155s
├─ Completed: 6.809028166s
└─ Errors:    0

posts50k - expand author [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author]

┌─ Best:      14.179736ms
├─ Worst:     155.553803ms
├─ Completed: 709.209313ms
└─ Errors:    0

posts50k - expand author (limited fields) [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author&fields=id,collectionId,expand.author.id]

┌─ Best:      20.060654ms
├─ Worst:     120.88189ms
├─ Completed: 747.437187ms
└─ Errors:    0

posts50k - expand author.permissions [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author.permissions]

┌─ Best:      28.587473ms
├─ Worst:     160.748884ms
├─ Completed: 981.212149ms
└─ Errors:    0

posts50k - expand author.permissions (limited fields) [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author.permissions&fields=id,collectionId,expand.author.id,expand.author.expand.permissions.id]

┌─ Best:      29.275329ms
├─ Worst:     209.359073ms
├─ Completed: 1.027493449s
└─ Errors:    0

posts50k - simple auth rule [reqs:100, conc:10, rule:"@request.auth.id != ''", query:?perPage=20]

┌─ Best:      20.723729ms
├─ Worst:     128.639712ms
├─ Completed: 572.127952ms
└─ Errors:    0

posts50k - author check (no index) [reqs:100, conc:10, rule:"author = @request.auth.id", query:?perPage=20]

┌─ Best:      109.303625ms
├─ Worst:     435.693106ms
├─ Completed: 2.575162583s
└─ Errors:    0

posts50k - author check (with index) [reqs:100, conc:10, rule:"author = @request.auth.id", query:?perPage=20]

┌─ Best:      7.803723ms
├─ Worst:     45.1079ms
├─ Completed: 212.751669ms
└─ Errors:    0

posts50k - author check (with index and skipTotal) [reqs:100, conc:10, rule:"author = @request.auth.id", query:?perPage=20&skipTotal=1]

┌─ Best:      6.171309ms
├─ Worst:     33.934078ms
├─ Completed: 186.976859ms
└─ Errors:    0

posts50k - author.id (extra join) check (no index) [reqs:100, conc:10, rule:"author.id = @request.auth.id", query:?perPage=20]

┌─ Best:      277.780003ms
├─ Worst:     1.010351749s
├─ Completed: 5.956506045s
└─ Errors:    0

posts50k - author.id (extra join) check (with index) [reqs:100, conc:10, rule:"author.id = @request.auth.id", query:?perPage=20]

┌─ Best:      9.816329ms
├─ Worst:     50.793975ms
├─ Completed: 239.140667ms
└─ Errors:    0

posts50k - author.id (extra join) check (with index and skipTotal) [reqs:100, conc:10, rule:"author.id = @request.auth.id", query:?perPage=20&skipTotal=1]

┌─ Best:      8.215807ms
├─ Worst:     39.568533ms
├─ Completed: 203.198562ms
└─ Errors:    0

posts50k - loose large text search (no index) [reqs:100, conc:10, rule:"description ~ 'ipsum dolor'", query:?perPage=20]

┌─ Best:      110.862796ms
├─ Worst:     565.106024ms
├─ Completed: 3.127074529s
└─ Errors:    0

posts50k - loose large text search (with index) [reqs:100, conc:10, rule:"description ~ 'ipsum dolor'", query:?perPage=20]

┌─ Best:      93.686427ms
├─ Worst:     501.993259ms
├─ Completed: 2.893328214s
└─ Errors:    0

posts50k - loose large text search (with index and skipTotal) [reqs:100, conc:10, rule:"description ~ 'ipsum dolor'", query:?perPage=20&skipTotal=1]

┌─ Best:      115.236132ms
├─ Worst:     590.277051ms
├─ Completed: 2.701208113s
└─ Errors:    0

posts50k - multiple select :each (no index, match-all) [reqs:100, conc:10, rule:"type:each != 'c'", query:?perPage=20]

┌─ Best:      1.135247839s
├─ Worst:     4.448099856s
├─ Completed: 27.405920848s
└─ Errors:    0

posts50k - multiple select :each (no index, match-all, skipTotal) [reqs:100, conc:10, rule:"type:each != 'c'", query:?perPage=20&skipTotal=1]

┌─ Best:      821.868945ms
├─ Worst:     3.806670446s
├─ Completed: 25.471170851s
└─ Errors:    0

posts50k - multiple select :each (no index, at-least-one) [reqs:100, conc:10, rule:"type:each ?!= 'c'", query:?perPage=20]

┌─ Best:      221.462352ms
├─ Worst:     939.902359ms
├─ Completed: 5.410782797s
└─ Errors:    0

posts50k - multiple select :each (no index, at-least-one, skipTotal) [reqs:100, conc:10, rule:"type:each ?!= 'c'", query:?perPage=20&skipTotal=1]

┌─ Best:      201.138015ms
├─ Worst:     808.211993ms
├─ Completed: 5.055856413s
└─ Errors:    0

posts50k - nested single relations lookup (no indexes) [reqs:100, conc:10, rule:"author.organization.name != 'test'", query:?perPage=20]

┌─ Best:      619.626649ms
├─ Worst:     2.418115144s
├─ Completed: 17.02610543s
└─ Errors:    0

posts50k - nested single relations lookup (no indexes, skipTotal) [reqs:100, conc:10, rule:"author.organization.name != 'test'", query:?perPage=20&skipTotal=1]

┌─ Best:      575.855851ms
├─ Worst:     3.335030393s
├─ Completed: 18.727763814s
└─ Errors:    0

posts50k - nested multiple relations lookup (no indexes, match-all) [reqs:100, conc:10, rule:"author.permissions.active = true", query:?perPage=20]

┌─ Best:      2.260867083s
├─ Worst:     5.767579339s
├─ Completed: 44.268675174s
└─ Errors:    0

posts50k - nested multiple relations lookup (no indexes, match-all, skipTotal) [reqs:100, conc:10, rule:"author.permissions.active = true", query:?perPage=20&skipTotal=1]

┌─ Best:      2.102309463s
├─ Worst:     5.383664191s
├─ Completed: 43.256666255s
└─ Errors:    0

posts50k - nested multiple relations lookup (no indexes, at-least-one) [reqs:100, conc:10, rule:"author.permissions.active ?= true", query:?perPage=20]

┌─ Best:      6.716164594s
├─ Worst:     13.149450752s
├─ Completed: 1m45.399570669s
└─ Errors:    0

posts50k - nested multiple relations lookup (no indexes, at-least-one, skipTotal) [reqs:100, conc:10, rule:"author.permissions.active ?= true", query:?perPage=20&skipTotal=1]

┌─ Best:      6.997713062s
├─ Worst:     12.663459688s
├─ Completed: 1m44.930255057s
└─ Errors:    0

posts100k - simpleA (many requests, no rules, no concurrency) [reqs:1000, conc:1, rule:"", query:?perPage=20]

┌─ Best:      8.272407ms
├─ Worst:     22.581945ms
├─ Completed: 9.604225557s
└─ Errors:    0

posts100k - simpleB (many requests, no rules, high concurrency) [reqs:1000, conc:1000, rule:"", query:?perPage=20]

┌─ Best:      209.627344ms
├─ Worst:     9.437076549s
├─ Completed: 9.461996732s
└─ Errors:    0

posts100k - simpleC (many requests, no rules, high concurrency, skipTotal) [reqs:1000, conc:1000, rule:"", query:?perPage=20&skipTotal=1]

┌─ Best:      974.399704ms
├─ Worst:     10.353750257s
├─ Completed: 10.355816384s
└─ Errors:    0

posts100k - mixed read and write (simpleA list with additional 300 concurrent random posts100k updates running in the background) [reqs:1000, conc:1000, rule:"", query:?perPage=20]

┌─ Best:      1.066447444s
├─ Worst:     12.376581946s
├─ Completed: 12.403440056s
└─ Errors:    0

posts100k - expand author [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author]

┌─ Best:      41.629651ms
├─ Worst:     266.69305ms
├─ Completed: 1.46944157s
└─ Errors:    0

posts100k - expand author (limited fields) [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author&fields=id,collectionId,expand.author.id]

┌─ Best:      30.970034ms
├─ Worst:     248.094908ms
├─ Completed: 1.336192511s
└─ Errors:    0

posts100k - expand author.permissions [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author.permissions]

┌─ Best:      57.846772ms
├─ Worst:     264.190609ms
├─ Completed: 1.657848545s
└─ Errors:    0

posts100k - expand author.permissions (limited fields) [reqs:100, conc:10, rule:"", query:?perPage=20&expand=author.permissions&fields=id,collectionId,expand.author.id,expand.author.expand.permissions.id]

┌─ Best:      58.950811ms
├─ Worst:     344.760067ms
├─ Completed: 1.806291003s
└─ Errors:    0

posts100k - simple auth rule [reqs:100, conc:10, rule:"@request.auth.id != ''", query:?perPage=20]

┌─ Best:      51.955024ms
├─ Worst:     291.846426ms
├─ Completed: 1.387168277s
└─ Errors:    0

posts100k - author check (no index) [reqs:100, conc:10, rule:"author = @request.auth.id", query:?perPage=20]

┌─ Best:      202.690736ms
├─ Worst:     991.544042ms
├─ Completed: 5.722418868s
└─ Errors:    0

posts100k - author check (with index) [reqs:100, conc:10, rule:"author = @request.auth.id", query:?perPage=20]

┌─ Best:      11.818577ms
├─ Worst:     81.065992ms
├─ Completed: 384.33497ms
└─ Errors:    0

posts100k - author check (with index and skipTotal) [reqs:100, conc:10, rule:"author = @request.auth.id", query:?perPage=20&skipTotal=1]

┌─ Best:      11.544145ms
├─ Worst:     38.656187ms
├─ Completed: 236.480822ms
└─ Errors:    0

posts100k - author.id (extra join) check (no index) [reqs:100, conc:10, rule:"author.id = @request.auth.id", query:?perPage=20]

┌─ Best:      529.952861ms
├─ Worst:     1.814120716s
├─ Completed: 11.872471138s
└─ Errors:    0

posts100k - author.id (extra join) check (with index) [reqs:100, conc:10, rule:"author.id = @request.auth.id", query:?perPage=20]

┌─ Best:      8.526679ms
├─ Worst:     101.472461ms
├─ Completed: 419.42524ms
└─ Errors:    0

posts100k - author.id (extra join) check (with index and skipTotal) [reqs:100, conc:10, rule:"author.id = @request.auth.id", query:?perPage=20&skipTotal=1]

┌─ Best:      15.258705ms
├─ Worst:     79.757352ms
├─ Completed: 342.140937ms
└─ Errors:    0

posts100k - loose large text search (no index) [reqs:100, conc:10, rule:"description ~ 'ipsum dolor'", query:?perPage=20]

┌─ Best:      238.66992ms
├─ Worst:     1.199614654s
├─ Completed: 7.997891863s
└─ Errors:    0

posts100k - loose large text search (with index) [reqs:100, conc:10, rule:"description ~ 'ipsum dolor'", query:?perPage=20]

┌─ Best:      298.344558ms
├─ Worst:     1.06338455s
├─ Completed: 6.749265805s
└─ Errors:    0

posts100k - loose large text search (with index and skipTotal) [reqs:100, conc:10, rule:"description ~ 'ipsum dolor'", query:?perPage=20&skipTotal=1]

┌─ Best:      259.988434ms
├─ Worst:     1.106768265s
├─ Completed: 7.266128157s
└─ Errors:    0

posts100k - multiple select :each (no index, match-all) [reqs:100, conc:10, rule:"type:each != 'c'", query:?perPage=20]

┌─ Best:      2.426460046s
├─ Worst:     8.31533733s
├─ Completed: 52.713328973s
└─ Errors:    0

posts100k - multiple select :each (no index, match-all, skipTotal) [reqs:100, conc:10, rule:"type:each != 'c'", query:?perPage=20&skipTotal=1]

┌─ Best:      2.318766293s
├─ Worst:     9.699806833s
├─ Completed: 54.485390179s
└─ Errors:    0

posts100k - multiple select :each (no index, at-least-one) [reqs:100, conc:10, rule:"type:each ?!= 'c'", query:?perPage=20]

┌─ Best:      433.466241ms
├─ Worst:     1.58403848s
├─ Completed: 10.098708651s
└─ Errors:    0

posts100k - multiple select :each (no index, at-least-one, skipTotal) [reqs:100, conc:10, rule:"type:each ?!= 'c'", query:?perPage=20&skipTotal=1]

┌─ Best:      456.975915ms
├─ Worst:     1.568682845s
├─ Completed: 9.992601472s
└─ Errors:    0

posts100k - nested single relations lookup (no indexes) [reqs:100, conc:10, rule:"author.organization.name != 'test'", query:?perPage=20]

┌─ Best:      1.017571293s
├─ Worst:     4.785731425s
├─ Completed: 32.807797986s
└─ Errors:    0

posts100k - nested single relations lookup (no indexes, skipTotal) [reqs:100, conc:10, rule:"author.organization.name != 'test'", query:?perPage=20&skipTotal=1]

┌─ Best:      1.285862074s
├─ Worst:     4.80145786s
├─ Completed: 32.225267136s
└─ Errors:    0

posts100k - nested multiple relations lookup (no indexes, match-all) [reqs:100, conc:10, rule:"author.permissions.active = true", query:?perPage=20]

┌─ Best:      4.941712766s
├─ Worst:     14.377296404s
├─ Completed: 1m39.371309268s
└─ Errors:    0

posts100k - nested multiple relations lookup (no indexes, match-all, skipTotal) [reqs:100, conc:10, rule:"author.permissions.active = true", query:?perPage=20&skipTotal=1]

┌─ Best:      5.845488653s
├─ Worst:     14.24530302s
├─ Completed: 1m37.37363986s
└─ Errors:    0

posts100k - nested multiple relations lookup (no indexes, at-least-one) [reqs:100, conc:10, rule:"author.permissions.active ?= true", query:?perPage=20]

┌─ Best:      7.54665981s
├─ Worst:     26.715525975s
├─ Completed: 3m28.842449445s
└─ Errors:    0

posts100k - nested multiple relations lookup (no indexes, at-least-one, skipTotal) [reqs:100, conc:10, rule:"author.permissions.active ?= true", query:?perPage=20&skipTotal=1]

┌─ Best:      6.827475627s
├─ Worst:     28.223152813s
├─ Completed: 3m32.160497324s
└─ Errors:    0

Go vs JS route execution

JS route (high concurrency) [reqs:500, conc:500]

┌─ Best:      286.27354ms
├─ Worst:     52.58334242s
├─ Completed: 52.594625872s
└─ Errors:    0

Go route (high concurrency) [reqs:500, conc:500]

┌─ Best:      1.265679643s
├─ Worst:     20.327443476s
├─ Completed: 20.566157356s
└─ Errors:    0

JS route (medium concurrency) [reqs:500, conc:50]

┌─ Best:      157.51631ms
├─ Worst:     4.835992266s
├─ Completed: 16.738479797s
└─ Errors:    0

Go route (medium concurrency) [reqs:500, conc:50]

┌─ Best:      142.658471ms
├─ Worst:     3.47530971s
├─ Completed: 14.184671995s
└─ Errors:    0

JS route (no concurrency) [reqs:500, conc:1]

┌─ Best:      20.494215ms
├─ Worst:     63.785519ms
├─ Completed: 13.467425903s
└─ Errors:    0

Go route (no concurrency) [reqs:500, conc:1]

┌─ Best:      20.99782ms
├─ Worst:     63.102812ms
├─ Completed: 13.348713954s
└─ Errors:    0

Go vs JS hooks execution

JS OnRecordBeforeUpdateRequest hook handler - [reqs:100, conc:10]

┌─ Best:      23.225549ms
├─ Worst:     131.820972ms
├─ Completed: 632.983748ms
└─ Errors:    0

Go OnRecordBeforeUpdateRequest hook handler - [reqs:100, conc:10]

┌─ Best:      7.645921ms
├─ Worst:     71.833444ms
├─ Completed: 376.642182ms
└─ Errors:    0

Deleting records

deleting 100 posts10k - simple (no cascade, no rule) [conc:10, rule:""]

┌─ Best:      12.169209ms
├─ Worst:     135.13445ms
├─ Completed: 641.321426ms
└─ Errors:    0

deleting 100 posts10k - simple (no cascade, with rule) [conc:10, rule:"@request.auth.id != ''"]

┌─ Best:      21.372174ms
├─ Worst:     158.521938ms
├─ Completed: 636.340046ms
└─ Errors:    0

deleting 100 posts25k - simple (no cascade, no rule) [conc:10, rule:""]

┌─ Best:      11.510094ms
├─ Worst:     272.472985ms
├─ Completed: 859.246798ms
└─ Errors:    0

deleting 100 posts25k - simple (no cascade, with rule) [conc:10, rule:"@request.auth.id != ''"]

┌─ Best:      7.507341ms
├─ Worst:     113.821345ms
├─ Completed: 481.933648ms
└─ Errors:    0

deleting 100 posts50k - simple (no cascade, no rule) [conc:10, rule:""]

┌─ Best:      16.09291ms
├─ Worst:     88.104306ms
├─ Completed: 505.974534ms
└─ Errors:    0

deleting 100 posts50k - simple (no cascade, with rule) [conc:10, rule:"@request.auth.id != ''"]

┌─ Best:      15.394646ms
├─ Worst:     136.048266ms
├─ Completed: 532.097986ms
└─ Errors:    0

deleting 100 posts100k - simple (no cascade, no rule) [conc:10, rule:""]

┌─ Best:      10.514825ms
├─ Worst:     57.577978ms
├─ Completed: 363.893959ms
└─ Errors:    0

deleting 100 posts100k - simple (no cascade, with rule) [conc:10, rule:"@request.auth.id != ''"]

┌─ Best:      10.061752ms
├─ Worst:     270.56245ms
├─ Completed: 523.188556ms
└─ Errors:    0

deleting 100 users - with cascade deleting all associated posts [conc:10, rule:""]

┌─ Best:      444.611045ms
├─ Worst:     17.125437183s
├─ Completed: 34.654935279s
└─ Errors:    0

deleting 100 organizations - with cascade deleting all users and associated posts [conc:10, rule:""]

┌─ Best:      595.429666ms
├─ Worst:     50.68481241s
├─ Completed: 1m46.711817646s
└─ Errors:    0

---

Completed!