Bug Slows down forum dramatically
- Thread starter JBlaze
- Start date
-
- Tags
- 4.2 additional admin admincp amount bug cache caching coders comment copyright cron currency customers database database error disable download error event extremely features footer forum free guests help image inactive install issue link logs manage member missing mods more mysql new only performance php prefix query server settings staff support tab ten thread threads timestamp topic total update updates url user vbcredits vbcredits ii vbseo vbulletin version
- Status
Darkwaltz4
Former Developer
The installer will indeed create the table if it is actually missing. Are you saying you cant access the admincp to run the installer?
When I run the installer, loads for 2 min and that same database error comes up (missing transaction table). Should I tick over write?
Darkwaltz4
Former Developer
Disable vbcredits before running the installer again (with allow overwrite)
Darkwaltz4
Former Developer
After some extensive profiling with the help of mokonzi, I think I've ironed out the query causing all the lag. You'll have to run this query:
Be sure to add your table prefix if using one.
Give it a couple minutes, and see if the CPU load and/or rendering speed of your site has improved.
Let me know!
Code:
ALTER TABLE `credits_transaction` ADD INDEX (`status` , `userid` , `timestamp`)Be sure to add your table prefix if using one.
Give it a couple minutes, and see if the CPU load and/or rendering speed of your site has improved.
Let me know!
Darkwaltz4
Former Developer
For all the the guys who posted performance issues that have been merged into this thread, see the previous post on how to fix it!
Last edited:
rootsxrocks
Customer
That link isn't working now, and I suddenly had issue with my secondary currency failing to work with vbookie creating a new event. this was without any other changes updates or additions. I am unsure if the server has had any updates that might have affected this. Has this Fix been integrated into the current install file ? or is there a new release that is coming soon ?
Cosmic
Active member
Could you create this as a new issue? This one is marked as fixed and it makes it much more likely that your post will be missed as a result.
Cosmic
Darkwaltz4
Former Developer
the link above the the post with the link contains the query you need to run.
it hasnt been put into the customer version, because i havent figured out a decent way to selectively apply such a query (it builds a new index), since i dont want to be needlessly reapplying that for every upgrade, but if you are affected by it you can apply it manually right away.
it hasnt been put into the customer version, because i havent figured out a decent way to selectively apply such a query (it builds a new index), since i dont want to be needlessly reapplying that for every upgrade, but if you are affected by it you can apply it manually right away.
- Status
