And you're doing a query per postbit in showthread?
So for my default setting of 50 posts per page, my showthread goes from 13 queries to 63 queries per page?
You might want to consider modifying the call for the postbits to add the email address there or better still to have mysql perform the md5 and return that.
I love this hack, it's great. And the postbit > postbit_legacy changes are small. But I can't take a performance hit like that on the database. When this bit is fixed I'll enable it again... until then disabled.
|