[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.