| Author |
FORUM SEARCH BUTTON |
FAdm. Tim Webbers *S1*
Fleet Admiral
Courageous Elite Commandos
Joined: May 08, 2005
Posts: 69
|  Posted: 2006-03-06 18:24
Whoa! That's insanity!
Judging by server performance, I'd say trying to put a backup in place if the DB got wiped would take a massive amount of time.
*Tim shakes a finger*
Apparently, someone hasn't been optimizing the DB tables.
(Wait, I was about to suggest something for Linux, but DS servers are on FreeBSD. Dern).
_________________
|
Bitopherous
1st Lieutenant
Joined: June 07, 2004
Posts: 264
From: Bottom of the pile
| Posted: 2006-03-06 21:14
We could just delete your inactive threads after 10 days. That might help keeping crap from three years ago from getting bumped, and cut down on the storage requirements. Of course, all the epic stories might be lost that Josef and Rogue Spear took time making...
_________________
What's supposed to go here again?
|
BackSlash
Marshal
Galactic Navy
Joined: March 23, 2003
Posts: 11183
From: Bristol, England
| Posted: 2006-03-06 21:23
Quote:
|
On 2006-03-06 18:24, V. Adm. Tim Webbers *S1* wrote:
(Wait, I was about to suggest something for Linux, but DS servers are on FreeBSD. Dern).
|
|
Not yet they aren't.
_________________
|
Shigernafy
Admiral
Joined: May 29, 2001
Posts: 5726
From: The Land of Taxation without Representation
| Posted: 2006-03-07 14:36
9 million?
The backup I have from a month or two ago weighs in at about 430mb in the database... though oddly I can rar it down to about 35mb.
And I didn't take a number of tables, since I have no need for subscription or coupon information - and the coupon table is huge.
I don't remember the record count, but I could provide more statistics sometime for the truly interested. I think the forums take up the vast majority of the space though.
And optimise table isn't really an option; there's isnt wasted space, at least of the type optimise can actually help with.
I tried upgrading to phpBB2 on my computer (just for kicks), which uses a fulltext search method, which means the database has to go through and index every word of every post, cataloguing the words used to come up with an index of what's where and how much... it took about an hour fourty if I remember right. Not fun. That should give you an idea though..
_________________
* [S.W]AdmBito @55321 Sent \"I dunno; the French had a few missteps. But they're on the right track, one headbutt at a time.\"
|
James Bum007
Grand Admiral
Pitch Black
Joined: April 23, 2003
Posts: 480
From: Queens, New York
| Posted: 2006-03-07 15:15
Nice Sig Bito.
_________________
|
BackSlash
Marshal
Galactic Navy
Joined: March 23, 2003
Posts: 11183
From: Bristol, England
| Posted: 2006-03-07 19:05
Quote:
|
On 2006-03-07 14:36, Shigernafy wrote:
9 million?
The backup I have from a month or two ago weighs in at about 430mb in the database... though oddly I can rar it down to about 35mb.
And I didn't take a number of tables, since I have no need for subscription or coupon information - and the coupon table is huge.
I don't remember the record count, but I could provide more statistics sometime for the truly interested. I think the forums take up the vast majority of the space though.
And optimise table isn't really an option; there's isnt wasted space, at least of the type optimise can actually help with.
I tried upgrading to phpBB2 on my computer (just for kicks), which uses a fulltext search method, which means the database has to go through and index every word of every post, cataloguing the words used to come up with an index of what's where and how much... it took about an hour fourty if I remember right. Not fun. That should give you an idea though..
|
|
RW had something like 10k posts, it went through it in a few seconds...
"Cheesy Creezy!", as someone once said....
_________________
|
English
Deutsch
Nederlands
)
