On: Cases where full scans are better than indexes

[raldi]

Nope; it was used every time we needed to look up whether someone was a subscriber, which was cached for some things but not all of them.

[raldi → raldi]

Self-replying to add: This wasn’t a particularly frequent occurrence.

[ollien → raldi]

What sort of events would trigger this lookup if it was infrequent?

[raldi → ollien]

It's hard to remember after 13 years, but for example if someone made a purchase and redeemed it, or checked the status of their subscription.

[ollien → raldi]

Makes sense :)