New SQL Server

Started by dschwab9, April 16, 2009, 03:15:08 PM

Previous topic - Next topic

Spiritwarrior

Great work, the forum is fast and haven't had any timeout errors since then.

Joshua Dickerson

Bono_ what are your calculations?
Come work with me at Promenade Group



Need help? See the wiki. Want to help SMF? See the wiki!

Did you know you can help develop SMF? See us on Github.

How have you bettered the world today?

Bono_

Quote from: groundup on April 29, 2009, 05:12:37 AM
Bono_ what are your calculations?

For SMF usually size of db is 100k posts = 100MB.

Tristan Perry

Quote from: Bono_ on April 29, 2009, 09:33:13 AM
Quote from: groundup on April 29, 2009, 05:12:37 AM
Bono_ what are your calculations?

For SMF usually size of db is 100k posts = 100MB.
I'd agree with that as a rough guide, give or take 25% from that. However remember that the docs site also (AFAIK) runs off the forum database too, meaning the database size is higher than 'normal'

Dragooon

Go to the 3rd page, metallica said that the community DB is nearing 3 GB.

Joshua Dickerson

Bono_: your calculations really don't have much to do with how much RAM is needed for the server.
Come work with me at Promenade Group



Need help? See the wiki. Want to help SMF? See the wiki!

Did you know you can help develop SMF? See us on Github.

How have you bettered the world today?

Bono_

Quote from: groundup on April 29, 2009, 12:41:08 PM
Bono_: your calculations really don't have much to do with how much RAM is needed for the server.
I just wondered how big is database, sure you will not buy server that will match your current needs. You will try to get one that can handle raise in traffic in next year or two.

It is nice that you shared specs, usually people hide them like it's top secret.

reviewsquad


Yigal

Question.  Is SMF the most popular forum software at current?
Yigal V.
Contact me by PM


do yourself a favour and not annoy support helpers by spamming or messaging for support
1.x Support | 2.x Support | 5Mods

Joshua Dickerson

Quote from: Yigal on April 30, 2009, 09:18:08 PM
Question.  Is SMF the most popular forum software at current?
No.
Come work with me at Promenade Group



Need help? See the wiki. Want to help SMF? See the wiki!

Did you know you can help develop SMF? See us on Github.

How have you bettered the world today?

Yigal

Yigal V.
Contact me by PM


do yourself a favour and not annoy support helpers by spamming or messaging for support
1.x Support | 2.x Support | 5Mods

IchBin™

These two forums have been around far longer than most. IMO, they are the most popular.
Free - phpBB
Paid - vBulletin
IchBin™        TinyPortal

Yigal

Out of all those, I think that Simple Machines LLC is much better than phpBB and vBulletin.  I've tried out many other forums, I personally like this one the best.

I hope other feel the same way.
Yigal V.
Contact me by PM


do yourself a favour and not annoy support helpers by spamming or messaging for support
1.x Support | 2.x Support | 5Mods

Kenny01

Quote from: Yigal on May 01, 2009, 12:12:19 AM
Out of all those, I think that Simple Machines LLC is much better than phpBB and vBulletin.  I've tried out many other forums, I personally like this one the best.

I hope other feel the same way.
You're correct.

Aleksi "Lex" Kilpinen

I've had quite a few "arguments" with a friend of mine that's a devoted phpbb fan. Usually things come down to preference in the end, different things done in different ways - and one likes the other better. :) Both are actually quite good forum softwares - but I couldn't think of swtiching over to phpbb myself ;)
Slava
Ukraini!


"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum. Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

How you can help SMF

Kenny01

Creating topics and posting is much easier with smf than vBulletin.

Dragooon

Quote from: Kenny01 on May 01, 2009, 03:52:11 AM
Creating topics and posting is much easier with smf than vBulletin.
I believe its a matter of choice. Some might think the same in vB's favor. I personally prefer SMF.

wjhdiz

Do you use MySQL DB or else?

Thanks.
Freedom of speech? It is freer if not speaking out.
Believing in God? Yes, talk with God every day through God creations.
Coding is poem and a way of keeping away from the troubled world.

Tristan Perry

Quote from: wjhdiz on May 01, 2009, 11:11:07 AM
Do you use MySQL DB or else?

Thanks.
I'm 99.9% certain they use a MySQL server - remember there was a time when SMF only supported MySQL, and it seems unlikely that SMF would have migrated to a new DB system.

Yigal

Quote from: Dragooon on May 01, 2009, 04:05:49 AM
Quote from: Kenny01 on May 01, 2009, 03:52:11 AM
Creating topics and posting is much easier with smf than vBulletin.
I believe its a matter of choice. Some might think the same in vB's favor. I personally prefer SMF.
True.  Also, in phpBB, it's really hard to install modifications.  When here, it's just like that.
Yigal V.
Contact me by PM


do yourself a favour and not annoy support helpers by spamming or messaging for support
1.x Support | 2.x Support | 5Mods

Advertisement: