Tomaž Jerman
Tomaž Jerman
## Improving ID generation The current state: ``` goos: darwin goarch: arm64 pkg: github.com/cortezaproject/corteza/server/pkg/id BenchmarkGenerator-12 30810 38893 ns/op 0 B/op 0 allocs/op ``` Running the most optimal version with a...
## Interesting benchmarks Benchmark for assigning values to compose record values. Didn't grab a pre benchmark, added due to curiosity. The numbers look impressive enough so we don't need to...
Are you sure? [Here](https://learn.microsoft.com/en-us/sql/t-sql/data-types/decimal-and-numeric-transact-sql?view=sql-server-ver16#arguments) it states that the default is 18
Ah... never mind; looked at the wrong thing.. my bad
Failing to reproduce... Tried triggering the "offending" workflow with another workflow. Potential issue if the workflow has a run as?
Asked for more info. If the workflow has run as set; the result seems similar; it doesn't lock the server but it's the closest I managed to get.
Running the benchmarking scripts we get this:  ```json {"scenario":"x100: basic build regular","operation":"unmaker","numbers":{"100-10000":{"min":3530,"max":4252,"avg":3812.55,"total":76251,"runs":[3845,3814,4035,3546,3530,4252,3667,3891,3708,3748,3654,3863,3626,3953,4120,3823,4090,3678,3553,3855]}},"meta":{}} {"scenario":"x100: basic build physical","operation":"unmaker","numbers":{"100-10000":{"min":3542,"max":4268,"avg":3819.15,"total":76383,"runs":[3901,3757,4021,3589,3542,4268,3688,3842,3757,3769,3671,3891,3637,3963,4137,3745,4067,3657,3600,3881]}},"meta":{}} {"scenario":"x100: basic CRUD regular","operation":"crud-create","numbers":{"100-10000":{"min":10,"max":46,"avg":14.38,"total":1438,"runs":[24,15,17,20,13,14,13,15,14,15,12,16,15,16,39,16,13,15,26,13,14,19,15,13,14,13,14,13,13,12,14,22,14,14,12,11,13,17,18,21,15,14,15,12,14,13,21,15,13,12,13,13,13,13,12,12,46,13,12,12,13,12,14,15,14,15,16,13,12,11,10,11,11,12,12,11,12,13,11,13,14,13,11,11,14,13,13,12,11,12,13,13,12,12,11,14,11,12,12,13]}},"meta":{}} {"scenario":"x100: basic CRUD regular","operation":"crud-lookup","numbers":{"100-10000":{"min":8,"max":24,"avg":10.21,"total":1021,"runs":[15,12,11,22,13,15,11,10,16,9,9,8,10,10,15,10,10,9,13,9,11,11,10,9,9,9,9,9,9,10,8,9,10,9,10,10,10,13,12,12,9,9,9,10,9,10,14,10,9,11,9,9,9,8,9,9,24,12,11,10,8,10,9,16,10,9,9,11,9,9,9,9,9,9,9,9,8,8,8,8,13,9,10,9,9,8,9,9,9,11,11,9,9,9,9,9,9,8,9,11]}},"meta":{}} {"scenario":"x100: basic CRUD regular","operation":"crud-update","numbers":{"100-10000":{"min":13,"max":37,"avg":17.42,"total":1742,"runs":[18,25,19,37,22,19,20,20,22,17,19,18,17,21,18,15,16,20,16,18,17,19,18,17,17,16,16,16,17,16,18,17,18,19,17,15,19,25,24,17,17,18,17,15,15,16,21,18,17,15,19,16,15,15,15,14,20,15,16,14,17,16,16,17,15,18,15,16,17,15,15,13,15,15,15,14,15,16,16,18,17,17,33,18,17,17,18,14,17,17,20,15,17,15,16,15,15,14,15,18]}},"meta":{}} {"scenario":"x100:...
Drafting a fix where we cache RBAC resources to hashmaps, we get to this  ```json {"special":"delimiter run line","ts":"2024-02-09T09:13:34.069Z"} {"scenario":"x100: basic build regular","operation":"unmaker","numbers":{"100-10000":{"min":3058,"max":6592,"avg":3688.9,"total":73778,"runs":[3607,3221,3339,3237,3082,3614,3102,3793,4850,3076,3058,6592,3549,3070,3231,3516,3256,5184,4301,3100]}},"meta":{}} {"scenario":"x100: basic build physical","operation":"unmaker","numbers":{"100-10000":{"min":3077,"max":6610,"avg":3701.6,"total":74032,"runs":[3623,3173,3323,3222,3130,3643,3113,3805,4867,3086,3077,6610,3566,3081,3241,3532,3269,5198,4322,3151]}},"meta":{}} {"scenario":"x100: basic CRUD...
Drafting a more proper solution (using a trie -- `pkg/ds`)  ```json {"special":"delimiter run line","ts":"2024-02-15T14:30:39.610Z"} {"scenario":"x100: basic build regular","operation":"unmaker","numbers":{"100-10000":{"min":2788,"max":5352,"avg":3380.85,"total":67617,"runs":[4326,3926,3171,3191,3352,3036,3055,3409,3033,5352,3077,2990,3237,2788,2888,3681,2896,2954,4386,2869]}},"meta":{}} {"scenario":"x100: basic build physical","operation":"unmaker","numbers":{"100-10000":{"min":2803,"max":5366,"avg":3392.9,"total":67858,"runs":[4340,3929,3185,3199,3366,3042,3065,3419,3044,5366,3092,3000,3244,2803,2893,3690,2934,2991,4336,2920]}},"meta":{}} {"scenario":"x100: basic CRUD regular","operation":"crud-create","numbers":{"100-10000":{"min":11,"max":38,"avg":14.05,"total":1405,"runs":[19,13,15,13,16,23,34,14,14,13,15,15,14,15,12,14,15,12,15,20,14,13,14,12,16,14,13,14,15,14,13,13,14,15,15,20,13,14,14,12,16,14,14,12,16,12,16,12,13,16,11,12,12,17,15,13,11,12,11,13,24,12,22,13,15,12,13,14,12,11,11,11,12,11,11,12,14,14,13,11,12,14,12,11,12,12,12,12,38,12,13,11,12,11,11,13,12,12,11,13]}},"meta":{}} {"scenario":"x100: basic CRUD...