Forum Statistics

From: Matt 9 Nov 2009 12:23
To: koswix 19 of 46
Archived posts as HTML files (compare a message's text to the HTML and CSS needed to display it) are probably not that much smaller than the data stored in the database, unless of course the flat files get compressed and then they arguably have a greater impact on the server.

Flat files are harder to index, prone to corruption much more than a database, harder to manage, can't be searched, etc.

So um, no :)
From: koswix 9 Nov 2009 15:21
To: Matt 20 of 46

Oh :(

 

But but but.

 

The old stuff is hardly ever looked at, so could be hived off into a seperate folder structure freeing up databse resources for the active content. Wouldn't that help general speed issues/server requirements?

 

And you could integrate a seperate 'search the archive' shit with a custom google search thing or something.

 

I'll shut up now :(

From: Ken (SHIELDSIT) 9 Nov 2009 15:56
To: koswix 21 of 46

Sounds like a great idea to me too. Take that as I have no idea what the fuck I'm talking about though.

 

Matt is probably right, my bits flow under the ocean and the stoopid ass fish are probably eating the lines or something. I know something is going on because it's very slow. Probably a jive ass sea monster.

From: Ken (SHIELDSIT) 9 Nov 2009 16:03
To: Ken (SHIELDSIT) 22 of 46
Fucking Norwals are at it again!
Attachments:
From: JonCooper 9 Nov 2009 17:49
To: koswix 23 of 46
tbh, I'd just delete most of the old stuff

maybe that could be an admin thing?
say, any thread which hasn't been read for a year is marked for deletion and is deleted a month later unless someone marks it for keeping
From: ANT_THOMAS 9 Nov 2009 17:52
To: JonCooper 24 of 46
I know I'd mark everything for keeps :$
From: JonCooper 9 Nov 2009 17:56
To: ANT_THOMAS 25 of 46
why?

some just don't need to be kept

evidence ~ thread 2
From: Matt 9 Nov 2009 17:59
To: Ken (SHIELDSIT) 26 of 46
Ken,

Can you try pinging tehforum.co.uk a large number of times (in excess of 100, say) and see if you get any packet loss?

I'm betting the problems you're seeing is due to the wet string between the US and Europe or maybe your ISPs routing partnership(s). I only say that as the server is pretty much idle at the moment, so you shouldn't be seeing any problems like the attached.
From: Ken (SHIELDSIT) 9 Nov 2009 18:26
To: Matt 27 of 46

Seems much better atm. When I notice it acting funky again I will do that and post the results.

 

I wouldn't get to worried about it on your end. If everyone is seeing good results it can't be you. I can put up with it being slow.

From: ANT_THOMAS 9 Nov 2009 18:50
To: Matt 28 of 46

To be fair it has been intermittently slow today for me.

 

Want me to ping the shit out of the server?

From: Matt 9 Nov 2009 19:06
To: ANT_THOMAS 29 of 46
Only if you're seeing the same error as Ken, with connection resets etc.
From: ANT_THOMAS 9 Nov 2009 19:09
To: Matt 30 of 46
Well I pinged 100 times with no packet loss, I've not had any connection resets so I guess the interwebs are being slow at times for me today.

code:
Ping statistics for 77.235.34.8:
    Packets: Sent = 100, Received = 100, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 26ms, Maximum = 92ms, Average = 37ms
From: Peter (BOUGHTONP) 9 Nov 2009 19:39
To: ANT_THOMAS 31 of 46
Slow? Bah! Your maximum time is less than my minimum!

code:
Ping statistics for 77.235.34.8:
    Packets: Sent = 100, Received = 97, Lost = 3 (3% loss),
Approximate round trip times in milli-seconds:
    Minimum = 119ms, Maximum = 2713ms, Average = 276ms
EDITED: 9 Nov 2009 19:39 by BOUGHTONP
From: ANT_THOMAS 9 Nov 2009 20:13
To: Peter (BOUGHTONP) 32 of 46
Ha! Well, you will carry on being stubborn and not get a phoneline.
From: Peter (BOUGHTONP) 9 Nov 2009 20:20
To: ANT_THOMAS 33 of 46
Bah, I was never supposed to be here this long, and I can't exactly go ask for one now.

Besides, this connection is supposed to give 7M HSPA speeds. :/
From: ANT_THOMAS 9 Nov 2009 20:23
To: Peter (BOUGHTONP) 34 of 46
But isn't the latency and therefore ping on mobile internet shit?
From: Peter (BOUGHTONP) 9 Nov 2009 20:35
To: ANT_THOMAS 35 of 46
The whole thing is shit, but I'm fairly sure in my case it's more because of Vodafone's endless levels of proxies and crap than a fault with 3G/HSPA itself.
From: Serg (NUKKLEAR)12 Nov 2009 17:51
To: Matt 36 of 46
I love the search phrases that get people here most of the time:

quote:
i love my cat make me want to eat it
goats teleported
hey fatty boom boom sweet sugar dumpling 60s song


And the epic win:
quote:
tea colour chart
From: Mouse12 Nov 2009 19:01
To: Serg (NUKKLEAR) 37 of 46
Goats teleported.. Was that from a game or something?
From: Matt12 Nov 2009 20:00
To: Mouse 38 of 46
It's a Google Chrome thing. It's some of the data in their data collector for reporting crashes.