21 sats \ 2 replies \ @k00b 21 Mar 2022 \ parent \ on: Daily discussion thread
Found a hack that reduces the cost from 548089.02 -> 5193.26, 100x improvement ... still need to test, but hopefully that will let us grow another couple months without overhauling notifications.
write
preview
0 sats \ 1 reply \ @gmd 22 Mar 2022
fascinating to read... there are probably papers out in obscure journals about how to optimize this... i'm amazed how responsive twitter notifications are as such a large scale...
reply
24 sats \ 0 replies \ @k00b 22 Mar 2022
They denormalize them most certainly (lots of data duplication in the data models) which is fast but relatively complex to maintain.
reply