changing dbqd.logger.www.lib.entries-table.select_entries to use all_users rather than cc_users makes the query go from 1400ms to 15ms on a system with 60k users. In any case I think you want all entries submitted even if a users site membership is subsequently revoked.
Loading ...