Anybody Else Having Problems With The Board?

IRG CommandoJoe · Post by **IRG CommandoJoe** » 2002-11-08 12:06am

IG-88E wrote:Mynocks. Probably chewing on the power cables.

(Hands out breath masks, DL-44's, and bowcasters to board members.)
(Opens ramp.)

XaLEv · Post by **XaLEv** » 2002-11-08 07:31am

What exactly will deleting the earlier posts do to make it better?

EDIT: And it's better here, now.

Post by **haas mark** » 2002-11-08 07:35am

It's all better for me.

Post by **Darth Wong** » 2002-11-08 08:00am

Is it still doing that? Or has it improved?

PS. I did some checking last night. Possible reasons for the problems may be server overloading (the server was noticeably sluggish when I SSH'd into it) which could indeed have to do with the size of the database. Statistics trivia: in the month of October, the board (not the entire SD.Net site, just the board sub-domain) registered an average of 250,000 hits per day (not individual visitors; obviously each visitor generates a lot of hits as he browses around). And the database is roughly 200MB.

Note: I could cut the database down to half its current size by eliminating the search-term tables; this would nuke searches, but preserve the entire message database. How important are text searches? Or is it a moot point? Is it running better now?

Post by **haas mark** » 2002-11-08 08:04am

It's running better. Well, for me, anyways.

XaLEv · Post by **XaLEv** » 2002-11-08 08:53am

It's better here, too.

Ted · Post by **Ted** » 2002-11-08 12:24pm

Darth Wong wrote:Is it still doing that? Or has it improved?

PS. I did some checking last night. Possible reasons for the problems may be server overloading (the server was noticeably sluggish when I SSH'd into it) which could indeed have to do with the size of the database. Statistics trivia: in the month of October, the board (not the entire SD.Net site, just the board sub-domain) registered an average of 250,000 hits per day (not individual visitors; obviously each visitor generates a lot of hits as he browses around). And the database is roughly 200MB.

Note: I could cut the database down to half its current size by eliminating the search-term tables; this would nuke searches, but preserve the entire message database. How important are text searches? Or is it a moot point? Is it running better now?

Its betrter now, but I dont think many people use the searches. And what about deleting all the July and most of the August posts? Would that help it?

aerius · Post by **aerius** » 2002-11-08 12:31pm

Ted wrote:And what about deleting all the July and most of the August posts? Would that help it?

Hey...wait a minute....we know that you lead the board in the deleted posts department, is this your idea of getting even with us?

Post by **Kuja** » 2002-11-08 12:34pm

Darth Wong wrote:Note: I could cut the database down to half its current size by eliminating the search-term tables; this would nuke searches, but preserve the entire message database. How important are text searches? Or is it a moot point? Is it running better now?

It's running smoothly. I personally haven't used the searches at all.

Ted · Post by **Ted** » 2002-11-08 12:34pm

aerius wrote:
Ted wrote:And what about deleting all the July and most of the August posts? Would that help it?
Hey...wait a minute....we know that you lead the board in the deleted posts department, is this your idea of getting even with us?

Of course not, but I would like to see how many posts Bean would loose.

Spanky The Dolphin · Post by **Spanky The Dolphin** » 2002-11-08 12:35pm

I vote no against deleting posts or threads.

I'd personally go with axing the search term tables.

And it's been working better since early this morning.

Spanky The Dolphin · Post by **Spanky The Dolphin** » 2002-11-08 01:02pm

It's starting to happen again...

Post by **Kuja** » 2002-11-08 01:03pm

Shit, it just did it twice again.

and again when I tried posting.

XaLEv · Post by **XaLEv** » 2002-11-08 01:04pm

I'm definitely against deleting threads. And I use the search reasonably often.

It's starting here again.

Arthur_Tuxedo · Post by **Arthur_Tuxedo** » 2002-11-08 02:09pm

Darth Wong wrote:Is it still doing that? Or has it improved?

PS. I did some checking last night. Possible reasons for the problems may be server overloading (the server was noticeably sluggish when I SSH'd into it) which could indeed have to do with the size of the database. Statistics trivia: in the month of October, the board (not the entire SD.Net site, just the board sub-domain) registered an average of 250,000 hits per day (not individual visitors; obviously each visitor generates a lot of hits as he browses around). And the database is roughly 200MB.

Note: I could cut the database down to half its current size by eliminating the search-term tables; this would nuke searches, but preserve the entire message database. How important are text searches? Or is it a moot point? Is it running better now?

Ack! Don't eliminate searches! That's all I do. I just Author search for Darth Wong and read what you've posted, then Admiralkanos, then myself to see if someone's responded to one of my pots. If I couldn't search, I'd probably just stop coming here, as I don't want to devote any significant portion of my day to this board.

Spanky The Dolphin · Post by **Spanky The Dolphin** » 2002-11-08 02:10pm

What? That's what you do?

I'm speechless.

Post by **Kuja** » 2002-11-08 02:13pm

You do all that searching? That probably takes longer than just going to your threads.

Kelly Antilles · Post by **Kelly Antilles** » 2002-11-08 02:16pm

you could just pull up Wong's profile and click all posts written.

But yeah, we've got too much traffic here.

Post by **Darth Wong** » 2002-11-08 02:35pm

Search by author would still work. It's just search by keyword that would be nuked.

EmperorMing · Post by **EmperorMing** » 2002-11-08 03:18pm

Man, this thing is still giving me headaches...The reload issue is still ongoing...

Kelly Antilles · Post by **Kelly Antilles** » 2002-11-08 03:20pm

There are 35 people on the board at the moment. If quite a few are trying to move around or search at the same time, the bandwidth is gonna suck with so much shit on the board. The server is loosing it.

EmperorMing · Post by **EmperorMing** » 2002-11-08 03:22pm

Ahhh! The price of popularity...

Vertigo1 · Post by **Vertigo1** » 2002-11-08 03:35pm

Ok, what about archiving the old posts from September and back, burning those to CD and removing them from the server?

(btw, its getting steadily worse for me. I have to try several times to even goto the next page in a thread.)

As for a new host, try http://www.3dfrontier.com/hosting/ . They've got some nice packages that might suit you just fine.

Kelly Antilles · Post by **Kelly Antilles** » 2002-11-08 03:45pm

Or, move old posts to a different server altogether, perhaps a free one, since it won't be accessed too much.

Kelly Antilles · Post by **Kelly Antilles** » 2002-11-08 03:53pm

Or, we could just make the board for registered users only.

I'm only throwing out thoughts.