Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Forum issues  (Read 7065 times)

0 Members and 1 Guest are viewing this topic.

Computer Hope Admin

    Topic Starter
  • Administrator


  • Prodigy

    Thanked: 248
    • Yes
    • Yes
    • Yes
    • Computer Hope
  • Certifications: List
  • Computer: Specs
  • Experience: Guru
  • OS: Windows 10
Forum issues
« on: December 21, 2019, 11:39:57 AM »
Greetings everyone,

Over the last month, Allan has brought up how slow the forum is at loading pages. I've been trying my typical steps I follow when things are slow, and they help temporarily, but things get slow again overtime. Because the server is not stressed, the rest of the site is still always fast, and things get temporarily resolved when repairing the database, I believe it's a database issue.

Over the next few days, I'll be cleaning things up and trying to get things to remain fast. This weekend I'll also be updating the server and also likely converting SMF database tables from MyISAM to InnoDB. I apologize for all the trouble and hope to get this resolved as soon as I can. Unfortunately, since I can't locate an exact cause of the problem, I have to keep trying different fixes until I can get it resolved.

Thank you for your patience,

-Nathan
Everybody is a genius. But, if you judge a fish by its ability to climb a tree, it will spend its whole life believing that it is stupid.
-Albert Einstein

patio

  • Moderator


  • Genius
  • Maud' Dib
  • Thanked: 1769
    • Yes
  • Experience: Beginner
  • OS: Windows 7
Re: Forum issues
« Reply #1 on: December 21, 2019, 12:25:04 PM »
Thanx for your hard work Nathan...
" Anyone who goes to a psychiatrist should have his head examined. "

Geek-9pm


    Mastermind
  • Geek After Dark
  • Thanked: 1026
    • Gekk9pm bnlog
  • Certifications: List
  • Computer: Specs
  • Experience: Expert
  • OS: Windows 10
Re: Forum issues
« Reply #2 on: December 21, 2019, 05:51:54 PM »
Thank you very much.  :)

Computer Hope Admin

    Topic Starter
  • Administrator


  • Prodigy

    Thanked: 248
    • Yes
    • Yes
    • Yes
    • Computer Hope
  • Certifications: List
  • Computer: Specs
  • Experience: Guru
  • OS: Windows 10
Re: Forum issues
« Reply #3 on: December 21, 2019, 10:43:15 PM »
Thanks. I spent the day doing various updates, removed several thousand members who haven't logged in for years with 0 posts, and updated server. I don't believe this will fix the issue. However, I think moving everything over to InnoDB should fix many things based on everything I've read and learned today. I will be backing up everything and trying that tomorrow night.
Everybody is a genius. But, if you judge a fish by its ability to climb a tree, it will spend its whole life believing that it is stupid.
-Albert Einstein

2x3i5x



    Expert
  • Thanked: 134
  • Computer: Specs
  • Experience: Familiar
  • OS: Windows 10
Re: Forum issues
« Reply #4 on: December 21, 2019, 10:44:03 PM »
Thank you for keeping CH alive and running well, Nathan :)

Computer Hope Admin

    Topic Starter
  • Administrator


  • Prodigy

    Thanked: 248
    • Yes
    • Yes
    • Yes
    • Computer Hope
  • Certifications: List
  • Computer: Specs
  • Experience: Guru
  • OS: Windows 10
Re: Forum issues
« Reply #5 on: December 22, 2019, 08:33:00 PM »
Thank you for keeping CH alive and running well, Nathan :)

Thanks 2x3i5x, I'm trying. :)
Everybody is a genius. But, if you judge a fish by its ability to climb a tree, it will spend its whole life believing that it is stupid.
-Albert Einstein

Computer Hope Admin

    Topic Starter
  • Administrator


  • Prodigy

    Thanked: 248
    • Yes
    • Yes
    • Yes
    • Computer Hope
  • Certifications: List
  • Computer: Specs
  • Experience: Guru
  • OS: Windows 10
Re: Forum issues
« Reply #6 on: December 22, 2019, 08:34:27 PM »
Success. Everything went smoothly with conversion, and everything seems to be running much faster. The real test will be to see how everything performs over time.

Thanks again everyone for your patience.

-Nathan
Everybody is a genius. But, if you judge a fish by its ability to climb a tree, it will spend its whole life believing that it is stupid.
-Albert Einstein

Allan

  • Moderator

  • Mastermind
  • Thanked: 1260
  • Experience: Guru
  • OS: Windows 10
Re: Forum issues
« Reply #7 on: December 23, 2019, 05:16:58 AM »
So far so good. Thanks Nathan.

Computer Hope Admin

    Topic Starter
  • Administrator


  • Prodigy

    Thanked: 248
    • Yes
    • Yes
    • Yes
    • Computer Hope
  • Certifications: List
  • Computer: Specs
  • Experience: Guru
  • OS: Windows 10
Re: Forum issues
« Reply #8 on: December 23, 2019, 11:25:54 AM »
That's good to hear and see. Hopefully things remain fast and maybe after making sure everything is stable I can try a few more things that I've read about that may speed things up even faster.
Everybody is a genius. But, if you judge a fish by its ability to climb a tree, it will spend its whole life believing that it is stupid.
-Albert Einstein

patio

  • Moderator


  • Genius
  • Maud' Dib
  • Thanked: 1769
    • Yes
  • Experience: Beginner
  • OS: Windows 7
Re: Forum issues
« Reply #9 on: December 23, 2019, 04:47:10 PM »
Now you can safely reset my Post count again...:P
" Anyone who goes to a psychiatrist should have his head examined. "