Huge performance boost when generating the filter-by-entity lists for blog posts and events. It turns out that the use of a subquery to retrieve just the IDs and an outer query to get the details for each entity is a major win with a large database of articles, entities, tags, etc. I believe this has to do with simplifying the inner query enough that the MySQL query optimizer can figure out what to do



git-svn-id: http://svn.apostrophenow.org/plugins/apostropheEntitiesPlugin/trunk@4984 c89fab08-2f9b-42bf-8176-bd3ad6bee547