[MarkFL]

Originally Posted by Zachery

Taking a quick look at your code, this could really send the query count up. It would be a very good idea to cache the data for 15-60 min at least. Each time you call can moderate (every page load) it also adds a query's worth of overhead. Plus on a forum with a lot of ignored users you'd really rack up a huge query list.

Additionally, it would be a good idea to query for all of the users in one shot. Then let php or the template system deal with formatting the users data from the array that got returned.

You should still cache that data some how though.

Thank you for you useful suggestions! :up:

Update version 1.5:

• The "can_moderate()" query is replaced with selected usergroup(s) in the product settings to determine if a user can view the ignored users in the WGO element.
• The "user" table is now queried only once rather than for each ignored user.

Once I learn how to cache data, I will implement it for this product.