Advertisement:
GCWebhosting

Author Topic: New SQL Server  (Read 316055 times)

Offline Spiritwarrior

  • Semi-Newbie
  • *
  • Posts: 35
  • Gender: Male
Re: New SQL Server
« Reply #100 on: April 28, 2009, 09:47:36 PM »
Great work, the forum is fast and haven't had any timeout errors since then.

Offline Joshua Dickerson

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,777
  • Gender: Male
    • joshuaadickerson on GitHub
    • joshuaadickerson on LinkedIn
Re: New SQL Server
« Reply #101 on: April 29, 2009, 05:12:37 AM »
Bono_ what are your calculations?
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?

Offline Bono_

  • Semi-Newbie
  • *
  • Posts: 10
Re: New SQL Server
« Reply #102 on: April 29, 2009, 09:33:13 AM »
Bono_ what are your calculations?

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

Offline Tristan Perry

  • SMF Hero
  • ******
  • Posts: 2,498
  • Gender: Male
    • Tristan Perry
Re: New SQL Server
« Reply #103 on: April 29, 2009, 09:40:02 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'

Offline Dragooon

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,738
  • Gender: Male
  • I'm bIn
    • ShitizGarg on Facebook
    • Dragooon on GitHub
    • dragooon on LinkedIn
    • SMF-Media
Re: New SQL Server
« Reply #104 on: April 29, 2009, 10:20:43 AM »
Go to the 3rd page, metallica said that the community DB is nearing 3 GB.

Offline Joshua Dickerson

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,777
  • Gender: Male
    • joshuaadickerson on GitHub
    • joshuaadickerson on LinkedIn
Re: New SQL Server
« Reply #105 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.
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?

Offline Bono_

  • Semi-Newbie
  • *
  • Posts: 10
Re: New SQL Server
« Reply #106 on: April 30, 2009, 05:50:48 AM »
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.

Offline reviewsquad

  • Semi-Newbie
  • *
  • Posts: 54
  • Gender: Male
    • Tips Cari Uang Internet
Re: New SQL Server
« Reply #107 on: April 30, 2009, 10:32:11 AM »
nice info  ;D

Offline Yigal

  • SMF Hero
  • ******
  • Posts: 2,703
  • Gender: Male
  • Om Nom Nom?
Re: New SQL Server
« Reply #108 on: April 30, 2009, 09:18:08 PM »
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

Offline Joshua Dickerson

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,777
  • Gender: Male
    • joshuaadickerson on GitHub
    • joshuaadickerson on LinkedIn
Re: New SQL Server
« Reply #109 on: April 30, 2009, 09:19:39 PM »
Question.  Is SMF the most popular forum software at current?
No.
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?

Offline Yigal

  • SMF Hero
  • ******
  • Posts: 2,703
  • Gender: Male
  • Om Nom Nom?
Re: New SQL Server
« Reply #110 on: April 30, 2009, 09:20:00 PM »
Oh, well then who is :P
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

Offline IchBin™

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,115
  • Gender: Male
  • I don't speak German.
Re: New SQL Server
« Reply #111 on: May 01, 2009, 12:07:35 AM »
These two forums have been around far longer than most. IMO, they are the most popular.
Free - phpBB
Paid - vBulletin
IchBin™        TinyPortal
Coding Guidelines       

Offline Yigal

  • SMF Hero
  • ******
  • Posts: 2,703
  • Gender: Male
  • Om Nom Nom?
Re: New SQL Server
« Reply #112 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.
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

Offline Kenny01

  • Sr. Member
  • ****
  • Posts: 767
  • Gender: Male
Re: New SQL Server
« Reply #113 on: May 01, 2009, 01:15:51 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.

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,409
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: New SQL Server
« Reply #114 on: May 01, 2009, 03:48:35 AM »
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 ;)
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"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

Offline Kenny01

  • Sr. Member
  • ****
  • Posts: 767
  • Gender: Male
Re: New SQL Server
« Reply #115 on: May 01, 2009, 03:52:11 AM »
Creating topics and posting is much easier with smf than vBulletin.

Offline Dragooon

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,738
  • Gender: Male
  • I'm bIn
    • ShitizGarg on Facebook
    • Dragooon on GitHub
    • dragooon on LinkedIn
    • SMF-Media
Re: New SQL Server
« Reply #116 on: May 01, 2009, 04:05:49 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.

Offline wjhdiz

  • Jr. Member
  • **
  • Posts: 363
Re: New SQL Server
« Reply #117 on: May 01, 2009, 11:11:07 AM »
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.

Offline Tristan Perry

  • SMF Hero
  • ******
  • Posts: 2,498
  • Gender: Male
    • Tristan Perry
Re: New SQL Server
« Reply #118 on: May 01, 2009, 11:19:45 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.

Offline Yigal

  • SMF Hero
  • ******
  • Posts: 2,703
  • Gender: Male
  • Om Nom Nom?
Re: New SQL Server
« Reply #119 on: May 01, 2009, 01:33:55 PM »
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