Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted May 6, 20159 yr Hi,i've just upgraded to 4.0.3. All is going fine (i think), it is taking ages to perform the background tasks (more than a million posts), i suppose it will take about more one day or two, but till now it seems ok.I have one issue though. The "Latest Topics" widget (which is fundamental for me) takes ages to load. With it my main page takes about 7-8 seconds to load. Without it is almost imediate. How can this be? With 3.4.x i had it and i had no problem whatsoever... Alternative suggestions?
May 7, 20159 yr Hi,i've just upgraded to 4.0.3. All is going fine (i think), it is taking ages to perform the background tasks (more than a million posts), i suppose it will take about more one day or two, but till now it seems ok.I have one issue though. The "Latest Topics" widget (which is fundamental for me) takes ages to load. With it my main page takes about 7-8 seconds to load. Without it is almost imediate. How can this be? With 3.4.x i had it and i had no problem whatsoever... Alternative suggestions?.Can you try the "customizable topic feed" .. you can do the same thing as "latest topics" with it .. at least you have some more filters to smooth things out .. .
May 7, 20159 yr I have same issue with latest topics or posts. If i use latest posts it is 100% sure that my site would go down and i start to receive 500 - timeout errors.Then i could just wait and when my site is live i can remove that widget. I have done it several times.
May 7, 20159 yr Are you using innodb? Latest Topics uses a query that utterly kills innodb. 3 min query on innodb vs .01 seconds on myisam. I bugged it but no response.
May 7, 20159 yr I have Database client version: libmysql - 5.1.73Server type: MySQLServer version: 5.5.40-log - MySQL Community Server (GPL)Protocol version: 10
May 7, 20159 yr Author Are you using innodb? Latest Topics uses a query that utterly kills innodb. 3 min query on innodb vs .01 seconds on myisam. I bugged it but no response. I do have innoDB, and i had to disable the widget too.Did you put at the bug tracker? I'll add some pressure to it Is it for that reason that IPS is not using that widget at this board?
May 7, 20159 yr Author Actually, I've just disabled this on our site, what a massive difference.Indeed! Something must be wrong with those queries!
May 7, 20159 yr Yeah I bugged it here:http://community.invisionpower.com/4bugtrack/402-latest-topics-widget-has-problems-on-innodb-r5447/
May 7, 20159 yr It took me ages to track down in mysql monitor...Removing access to Activity Stream and disabling Latest Topics made my load go from 10.0 and unable to stay online, to 0.40 and snappy.
May 7, 20159 yr Author Removing access to Activity Stream...Nice suggestion!Where can you disable that? I cannot find it in ACP?
May 7, 20159 yr Nice suggestion!Where can you disable that? I cannot find it in ACP?System > Applications > System > Activity Stream > Disable
Archived
This topic is now archived and is closed to further replies.