Welcome to Australia's only Vintage Radio and Television discussion forums. You are not logged in. Please log in below, apply for an account or retrieve your password.
Australian Vintage Radio Forums
  Home  ·  About Us  ·  Discussion Forums  ·  Glossary  ·  Outside Links  ·  Policies  ·  Services Directory  ·  Safety Warnings  ·  Tutorials

General Discussion

Forum home - Go back to General discussion

 Slow response from site
« Back · 1 · Next »
 Return to top of page · Post #: 1 · Written at 10:27:13 PM on 10 June 2020.
GTC's avatar
 GTC
 Location: Sydney, NSW
 Member since 28 January 2011
 Member #: 823
 Postcount: 6678

Lately I find the site's response quite sluggish, but mainly when creating a new post.

During the delay period Firefox displays "Sending request to vintage-radio.com.au ..." which can be seen for 30 seconds or longer.

During subsequent editing of a new post the response is fine. Very odd.


 
 Return to top of page · Post #: 2 · Written at 10:54:28 PM on 10 June 2020.
Ian Robertson's Gravatar
 Location: Belrose, NSW
 Member since 31 December 2015
 Member #: 1844
 Postcount: 2363

Yes, it looks like the database for General Discussion is getting too big. Other forums seem fine.


 
 Return to top of page · Post #: 3 · Written at 5:29:20 AM on 11 June 2020.
Brad's avatar
 Administrator
 Location: Naremburn, NSW
 Member since 15 November 2005
 Member #: 1
 Postcount: 7290

Last weekend I pinpointed the issue and it's not one I can fix easily - for now. It's a case of too many members rather than database too big.

When one starts a new thread or adds a comment to an existing thread a fairly basic loop runs to update the 'unread comments' column in every member's section with their latest number of unread postsand this powers everyone's unread post highlighting function, which makes the thread topics bold and turns the notepad icons in the left site column yellow instead of white.

In a week or two, certainly before the end of June, I am going to clear this table in the database so this function is handling less data. The last time I cleared it was about two years ago when we started having issues with all the 500 Errors, as I thought this was what was causing it (unfortunately it wasn't the cause - TPG was, go figure!).

Clearing the stale data from the table will speed things up a little, as data from idle members won't be cycled through the loop.

In the weeks following this I will rewrite the highlight update feature in ASP.NET, which should solve the problem in its entirety as ASP.NET works at up to 6,000 times faster than Classic ASP, given that ASP.NET is a compiled environment rather than simply a scripting language. To see the difference in speed, navigate through the static content on the white VR site pages.

The trick is writing code that works. Watch this space.


‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾
A valve a day keeps the transistor away...

 
 Return to top of page · Post #: 4 · Written at 6:03:32 AM on 11 June 2020.
Brad's avatar
 Administrator
 Location: Naremburn, NSW
 Member since 15 November 2005
 Member #: 1
 Postcount: 7290

Okay, due to me getting a 500 Error when making the previous post, I've decided to clear the thread highlighting now. Things should be much better now.


‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾
A valve a day keeps the transistor away...

 
 Return to top of page · Post #: 5 · Written at 10:56:50 AM on 11 June 2020.
Ian Robertson's Gravatar
 Location: Belrose, NSW
 Member since 31 December 2015
 Member #: 1844
 Postcount: 2363

Yes Brad so it seems! Thanks!


 
 Return to top of page · Post #: 6 · Written at 11:00:50 AM on 11 June 2020.
Robbbert's avatar
 Location: Hill Top, NSW
 Member since 18 September 2015
 Member #: 1801
 Postcount: 2011

This has been an issue for a while now, so thanks for fixing it. Smile

I was thinking you could also delete everyone who has 0 posts, but there aren't many members in that situation.


 
 Return to top of page · Post #: 7 · Written at 11:35:32 AM on 11 June 2020.
Brad's avatar
 Administrator
 Location: Naremburn, NSW
 Member since 15 November 2005
 Member #: 1
 Postcount: 7290

Accounts can't be closed. Once I get a chance to recode this function in .NET it should permanently fix the issue.

The idle members each had more than 100kB of data in the table. That times 2422 isn't a good size to have running through a loop coded in VBScript.


‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾‾
A valve a day keeps the transistor away...

 
 Return to top of page · Post #: 8 · Written at 12:06:31 PM on 11 June 2020.
Vintage Pete's avatar
 Location: Albury, NSW
 Member since 1 May 2016
 Member #: 1919
 Postcount: 2048

I would be a idle member for sure.
It's all my fault,,,,I really need to spend less time on computers at nights.
Addictive things!

Pete


 
« Back · 1 · Next »
 You need to be a member to post comments on this forum.

Sign In

Username:
Password:
 Keep me logged in.
Do not tick box on a computer with public access.