This plugin adds a lot of queries. If I add the profile fields to the postbit manually, no queries are added, because all of the fields are already joined on each post. However, if I use this plugin, a thread with 13 posts goes from 10 queries to 140! That's quite a lot of extra load for the database for bringing up a single page with 4 extra profile fields.
Looking at the code, it looks like the problem is that you are doing a separate query for each profile field and for each post, thus the extra queries needed become exponential for the number of posts per page and the number of profile fields. Since the fields are already loaded and available, you might see if you can use them instead of querying for them separately.
Hope that helps.
|