[dreamwidth/dw-free] 24bd9e: Optimize esn-filter-subs

[github]

Branch: refs/heads/release-1.12
Home: https://github.com/dreamwidth/dw-free
Commit: 24bd9ece3f451aabf7e0be187e032efe99fb8438
https://github.com/dreamwidth/dw-free/commit/24bd9ece3f451aabf7e0be187e032efe99fb8438
Author: mark <mark@dreamwidth.org>
Date: 2012-12-01 (Sat, 01 Dec 2012)

Changed paths:
M cgi-bin/LJ/ESN.pm

Log Message:
-----------
Optimize esn-filter-subs

This method was loading every user one by one, and every
subscription. Now it loads things in bulk, which makes the database
happier.

As a data point: prior to this, our database was doing north of 1000
queries per second in this codepath. Now it does 10.

Comments

[kareila]

http://bugs.dwscoalition.org/show_bug.cgi?id=4752

(please remember to include bug numbers in commit messages)

[mark]

Oops -- sorry about that. Thank you for looking them up!

[kareila]

It wasn't difficult, thanks to D's supplemental code tour. Thank you both. :)