←back to thread

Why AO3 Was Down

(www.reddit.com)
151 points danso | 2 comments | 05 Jul 25 02:23 UTC | HN request time: 0.422s | source
Show context
RainyDayTmrw ◴[05 Jul 25 05:19 UTC] No.44470247[source]▶
It's kinda impressive that they got to 2 billion rows - with indexes, no less - without falling over.
replies(1): >>44471169 #
1. jiggawatts ◴[05 Jul 25 08:47 UTC] No.44471169[source]▶
Point queries — typical of this kind of app - scales as log(n) in the number of rows. (Assuming a typical b-tree database index.)

This kind of workload cheerfully “scales” to your disk capacity.

replies(1): >>44477412 #
2. RainyDayTmrw ◴[06 Jul 25 02:47 UTC] No.44477412[source]▶
Locking would make that more complex, I believe?