Vincent Orr

Just been taking a look at that embedding files into the binary…. it’s not easy :sob: So all the conversion of the files happens in `cardano-db/` so we’d have to...

We had a discussion about how to implement this: ### Setup.hs `cardano-db-sync/Setup.hs` deals with converting `schema/*` -> `[KnownMigration]` to the binary at build time. The ideas would be to add...

> I ask again. How is the static binary tarball generated? with nix I assume 🤷

There is going to be a slight delay on this as we can only go ahead one `cardano-node` has done this work too. By that time I'd imagine we'll have...

@rdlrt interesting, I like the ideas. We'd have to think of scenarios where configs are changed back and forth by the user and how that might effect snapshots. Also so...

> In most case we decide to use autoincremental ids of referenced hashes. For example in reward.addr_id, epoch_stake.addr_id we use the id instead of the hash directly. Resolving this id...

Take that back I can see we have `type StakeAddrCache = Map StakeCred DB.StakeAddressId` which should be doing what I'm thinking but I can't spot it being populated in the...

That's a good point I've been trying to look at memory profiling see if I can work out what is consuming the most memory as right now on my mac:...

Some stats about different implementations -------------------------------------------------------------------------------------------------- StrictSeq + StrictMap memory 16.3GB Epoch 432 [15:27 -> 15:58] ~29mins Stake Addresses: cache sizes: 1287547 and 31415, hit rate: 57%, hits: 1821628, misses:...

ok think I've found it: `onlyDelete "PoolStat" [PoolStatEpochNo >. epochN]` should be `onlyDelete "PoolStat" [PoolStatEpochNo >=. epochN] ` https://github.com/IntersectMBO/cardano-db-sync/blob/e00405dd4f26212cedcc1b20c92aba38ed8009ee/cardano-db/src/Cardano/Db/Operations/Delete.hs#L122-L138 Will write tests see if that's the case