B Basti Customer Mar 27, 2012 #1 Hi. I cannot upgrade to v3 because the script running too long. My dbtech_vbactivity_pointslog table ist 1gb + 1,6gb index. can you tell me what mysql querys to run? then i wil execute them manually. thanks
Hi. I cannot upgrade to v3 because the script running too long. My dbtech_vbactivity_pointslog table ist 1gb + 1,6gb index. can you tell me what mysql querys to run? then i wil execute them manually. thanks
Fillip H. Staff member Owner Developer Customer Mar 27, 2012 #2 Truncate then Optimize that table, then re-populate it via the Recalculate Points maintenance script after upgrading
Truncate then Optimize that table, then re-populate it via the Recalculate Points maintenance script after upgrading