Bug credits.php has a very slow query and lags whole forum.

[ENZO-F]

This is on the pro version but i'm not the license owner. Check for the license under the domain name.

credits.php casuses extreme lag, sometimes taking out whole forum, when someone tries to run it. The page doesn't load with this and usually ends up with a DB Error.

To reproduce:
- With vBShop installed, use a currency for vBShop from vBCredits.
- Add a currency to vBCredits that uses the fields of vBShop's bank. (No events for currency.)
- Load credits.php

This issue happens every time the script is loaded on the forum.

 

[Fillip H.]

It would help if you posted the query in question

 

[ENZO-F]

It would help if you posted the query in question

Here you go:

SELECT userfield.*, usertextfield.*, user.*, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, (user.credits) AS vbcredits_1, user.credits AS vbcreditsb_1, (vbcreditst_3.points) AS vbcredits_3, vbcreditst_3.points AS vbcreditsb_3 FROM user AS user LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN dbtech_vbshop_bank AS vbcreditst_3 ON (user.userid = vbcreditst_3.userid) ORDER BY vbcredits_3 DESC LIMIT 10

 

[Darkwaltz4]

Was this slow with the regular credits currency, or only upon adding the vbshop currency? Can you swap back briefly to compare?

 

[ENZO-F]

Was this slow with the regular credits currency, or only upon adding the vbshop currency? Can you swap back briefly to compare?

It is currently slow with the default currency only and with both added.

 

[Darkwaltz4]

Those are from the top x lists along the side. You can disable those temporarily by setting 0 as the number of top stats in your main vbcredits configuration.

After doing that, let me know if it improves - will probably have to add an index on the currency column on your table to get it to work nice, but want to make sure that removing only that feature brings your site back to life.

 

[ENZO-F]

Those are from the top x lists along the side. You can disable those temporarily by setting 0 as the number of top stats in your main vbcredits configuration.

After doing that, let me know if it improves - will probably have to add an index on the currency column on your table to get it to work nice, but want to make sure that removing only that feature brings your site back to life.

That did the trick