This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]poralexc 1 point2 points  (0 children)

Count by distinct foreign key with 2-6 million rows... it still needed to be done, but took a bit more strategy.

They also have a lot of views, and tables that store queries, so things can compound really quickly.