StarDestroyer.Net BBS

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

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

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

EDIT: And it's better here, now.

It's all better for me.

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?

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

It's better here, too.

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?

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?

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.

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.

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.

It's starting to happen again...

Shit, it just did it twice again.

and again when I tried posting.

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


It's starting here again.

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.

What? That's what you do?

I'm speechless.

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

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

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

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

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

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.

Ahhh! The price of popularity...

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.

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

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

I'm only throwing out thoughts.