awskii

Results 33 comments of awskii

i suppose to use cacheEvery=2 as we thought we use before. Going to distinct if not affected by #10869 today.

confirmed that whole perf test here is screwed and related to #10869 and other recent updates to `main. Clean test later on.

I added last-mile optimisation: if R-L > 8 - scan one by one. Picked M for now is 256: optimal usage of memory and access time.

i broke a prune yet still it's good solution. will fix in the morning.

``` N: 12000000, M: 256 skip since shard

- getLatestFromDB was reworked to use valsTable, it is just a Seek + Check if stripped key == input key. Commitment have variable length keys so Instead we move cursor...

another on polygon with #12275 ``` [DBUG] [10-11|02:16:03.561] [index] write file=v1-062342-062343-transactions.idx [DBUG] [10-11|02:16:03.565] [index] created file=/erigon-data/snapshots/v1-062342-062343-transactions-to-block.idx.tmp [DBUG] [10-11|02:16:03.565] [index] calculating file=v1-062342-062343-transactions-to-block.idx [WARN] [10-11|02:16:03.650] [dbg] DomainGetFromFileCache a=accounts hit=7 total=16 Collisions=0 Evictions=0...

I think for such questions we should decide first the other thing: what is our expected default environment? In my opinion, most of our users will start erigon on cloud/remote...