Forum speed test

3 watchers
May 2019
11:40am, 1 May 2019
21,749 posts
  •  
  • 0
fetcheveryone
Testing adding a new post
May 2019
11:41am, 1 May 2019
21,750 posts
  •  
  • 0
fetcheveryone
It does seem to be a bit better.
May 2019
11:42am, 1 May 2019
21,751 posts
  •  
  • 0
fetcheveryone
Another test.
May 2019
11:42am, 1 May 2019
21,752 posts
  •  
  • 0
fetcheveryone
And heck why not, one more.
May 2019
11:46am, 1 May 2019
21,754 posts
  •  
  • 0
fetcheveryone
All the above seem to have happened quite zippily.
May 2019
11:49am, 1 May 2019
21,755 posts
  •  
  • 0
fetcheveryone
And just another check as I tidy up behind myself.
May 2019
11:52am, 1 May 2019
31,225 posts
  •  
  • 0
HappyG(rrr)
It was bad at 8am 9am, but seems all better now? :-) G
May 2019
11:58am, 1 May 2019
21,756 posts
  •  
  • 0
fetcheveryone
Yeah, I think I've found the cause of the problem.
May 2019
12:09pm, 1 May 2019
21,757 posts
  •  
  • 0
fetcheveryone
In a nutshell:

1) Each post in the forum is stored in a database.
2) Every forum page is a chunk of HTML code made by sewing a set of posts together.
3) To save regenerating these all the time, we store the HTML chunk in a text file.

Every time there's a new post, we need to delete that chunk, so we can remake it with the new post added.

However... if you have too many chunks of HTML stored, it becomes a bigger overhead to find and remove/update the relevant files. This was the case here. We were holding on to cached pages that were over a month old. The likelihood is that most of these weren't being looked at (at least not regularly), so all they were doing was slowing stuff down.

I've put something in place that means that any cached forum page older than 20 minutes will get deleted. That means our cache has about 200-300 files to juggle, rather than the 91834 files it *was* juggling :-)

Every day's a school day :-)

The good news is that I have some potential speed improvements to make elsewhere on the site, by making sure other caches have this balance right.
May 2019
1:26pm, 1 May 2019
21,760 posts
  •  
  • 0
fetcheveryone
All seems to be ok now :-)

About This Thread

Maintained by fetcheveryone
You can safely ignore this thread (but equally, feel free to have a chat on it). I'm just using...

Related Threads

  • archive
  • website









Back To Top
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 112,263 Fetchies!
Already a Fetchie? Sign in here