Blog Documentation Try Vanilla Cloud
Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

[GitHub Bug #895] Sometime Vanilla is very very slow.

legrandselegrandse ✭
edited October 2011 in Vanilla 2.0 - 2.8
Hello,

Can someone tell me why when I want to login into my forum (2.0.17.10) sometime the login connection is fast and sometime it is very slow (about 45sec) to login.

Sometime the login window is empty and I can't put anything into it. I have to wait 1 minute before elements like fields login an pass appears.

I' ve already done an update according to the wiki but the problem is still present.

Thanks for your comments/advices.

Tagged:

Answers

  • UnderDogUnderDog MVP
    Do you have vanilla on your local computer or do you have vanilla forums on a webhost? Where is it slow? Local or on the host.

    There was an error rendering this rich post.

  • legrandselegrandse ✭
    edited October 2011
    It is slow only on the host.
  • UnderDogUnderDog MVP
    Ok, if you don't have vanilla on your local PC, install it on your local PC and compare the speeds. Also try different browsers and compare those speeds.
    Last compare the speed by time of day.

    There was an error rendering this rich post.

  • GillinghamGillingham ✭
    Turn on debug mode and see what queries vanilla says are slow, also enable slow query tracking in MySQL.
    Vanillas activity queries in generally can be extremely slow as reported here
  • UnderDogUnderDog MVP
    edited October 2011
    *Merge with http://vanillaforums.org/discussion/comment/139564#Comment_139564 when merge functionality works*

    Also execute the slow queries in phpMyAdmin and then hit the "Explain" option so you see what the problem is. Maybe paste it here in < pre > < /pre > tags (no spaces)

    Left joins in queries is always slower than inner joins, especially with thousands of users.

    There was an error rendering this rich post.

  • camocamo New
    Are slow queries generally related to installed plugins or core functions?
    occasionally some tables related to plugins have overhead and after repairing and optimising there is a small but significant improvement in speed.
    I do find however that any function in dashboard is quite slow.
  • legrandselegrandse ✭
    Hello,

    Thank you for your advices.
    I've enabled the debug mode but for now it'is normal.

    The problem is not present each time.

    I will post the result when it appears.

    For UnderDog, I've also vanilla on a wampserver and never see any problem like on the host.

  • sudokuesudokue New

    I am having very slow response with 17.10 on a Unix / Apache server.

    Is the Vanilla MySQL DB tuned up by a SQL expert prior to each release?

    Are their any SQL experts on the Vanilla core team?

    End Users who want to install a Forum for their site should not have to suffer the debugging recommended above to get a decent response.

    Try my blazingly slow forum at http://www.forum.sudokue.com/

    Is the 2.0.18 release any faster esp for Dashboard use?

  • sahotataransahotataran ✭✭✭

    it worked great for me. just clicked the link and the forum showed up instantly

    There was an error rendering this rich post.

Sign In or Register to comment.