| View previous topic :: View next topic |
| Author |
Message |
Rocke_T_Sinetist Moderator
Joined: 26 Aug 2005 Posts: 2608 Location: DFW airport
|
Posted: Thu Sep 11, 2008 1:11 pm Post subject: Anyone notice we have 5000 more users than posted topics? |
|
|
Seems an odd statistic, but we have 5000 more registered users than posted topics. That's topic headings, not individual frames.
Statistics don't make much sense unless you know how they are derived. Literally countless spam posts have been deleted, so that reduces the topic count. As many as 10 spammers register for every 1 who manages to get through the verification and post. And since spammers/spambots are 99% hit and run, there's no point in deleting their membership status and they continue to add up.
Here's something remarkable. The whole IHD database, all the members, all the posts, occupies less than 60MB on a server. That's something like 1/1000th of one SMALL consumer harddrive. _________________ Rocke T Sinetist
as in, 'it doesn't take a...' |
|
| Back to top |
|
 |
Sponsor
|
|
 |
hotrodlincoln Moderator
Joined: 08 Apr 2003 Posts: 1691 Location: Not in Austin anymore
|
Posted: Thu Sep 11, 2008 8:17 pm Post subject: only 60MB??? |
|
|
| I am TOTALLY impressed with the compactness of the database. What is being used again: MySQL, PostGreSQL, or something else? Hell, if this site was using MS Access it would probably be over 300MB and would crash all the time because it's not designed for more than 3 users querying it at the same time. |
|
| Back to top |
|
 |
FallenAngel Super Hater
Joined: 21 Feb 2006 Posts: 1492
|
Posted: Thu Sep 11, 2008 10:00 pm Post subject: |
|
|
| PHPBB operates with SQL backbone. |
|
| Back to top |
|
 |
Rocke_T_Sinetist Moderator
Joined: 26 Aug 2005 Posts: 2608 Location: DFW airport
|
Posted: Fri Sep 12, 2008 10:28 am Post subject: |
|
|
And considering the uptime, it's NOT running on Windows Server. There's just nothing quite like Microshaft slothware. (Thank gawd.) _________________ Rocke T Sinetist
as in, 'it doesn't take a...' |
|
| Back to top |
|
 |
Sponsor
|
|
 |
hotrodlincoln Moderator
Joined: 08 Apr 2003 Posts: 1691 Location: Not in Austin anymore
|
Posted: Fri Sep 12, 2008 7:47 pm Post subject: |
|
|
| FallenAngel wrote: | | PHPBB operates with SQL backbone. |
So it has its own version of an SQL database built in? Interesting. |
|
| Back to top |
|
 |
diashto Moderator

Joined: 11 Nov 2006 Posts: 338 Location: Detroit area
|
Posted: Fri Sep 12, 2008 8:00 pm Post subject: |
|
|
| hotrodlincoln wrote: | | FallenAngel wrote: | | PHPBB operates with SQL backbone. |
So it has its own version of an SQL database built in? Interesting. |
Nope, its a pretty standard SQL database, nothing spectacularly unique to it, with php used to do the querys and such. |
|
| Back to top |
|
 |
hotrodlincoln Moderator
Joined: 08 Apr 2003 Posts: 1691 Location: Not in Austin anymore
|
Posted: Sat Sep 13, 2008 2:26 pm Post subject: |
|
|
| diashto wrote: |
Nope, its a pretty standard SQL database, nothing spectacularly unique to it, with php used to do the querys and such. |
So what's it called? If it's not the ones I mentioned already, then I can't think of its name. |
|
| Back to top |
|
 |
diashto Moderator

Joined: 11 Nov 2006 Posts: 338 Location: Detroit area
|
Posted: Sun Sep 14, 2008 9:01 am Post subject: |
|
|
It really depends on how the server is set up.. PostgreSQL requires some tweaking of the databases and such to get working, MySQL works right out of the box, so most admins use MySQL if it's available.
http://www.phpbb.com/support/documents.php?mode=install#require
I know the couple that i have installed on various domains i administer to use MySQL, because my webserver has free unlimited MySQL databases. |
|
| Back to top |
|
 |
Sponsor
|
|
 |
|