+  Forum Owners
|-+  The Beginner Forum Owner: Starting a Forum» Software Selection» Database usage
Username:
Password:
Pages: [1]
  Print  
Author Topic: Database usage  (Read 461 times)
pulse
Jr. Member
**
Offline Offline

Posts: 61


View Profile
« on: May 20, 2007, 09:42:46 AM »

Has anyone found that any of the free forum solutions gives heavier or lighter db server loads?
Logged
Harry
Newbie
*
Offline Offline

Posts: 26


View Profile
« Reply #1 on: July 02, 2007, 08:05:03 PM »

It really depends on the program and how large the database is, as well as how many users are online. vBulletin is pretty good I think speed wise and so is IPB. The paid software is usually better in terms of server loading.
Logged
Gordon
Newbie
*
Offline Offline

Posts: 10


View Profile
« Reply #2 on: January 08, 2008, 04:12:59 PM »

The new phpBB has server load adjustments in the admin control panel.
Logged

thughes
Jr. Member
**
Offline Offline

Posts: 96


View Profile
« Reply #3 on: January 08, 2008, 06:51:22 PM »

Does allow you to tune database usage?
Logged
Gordon
Newbie
*
Offline Offline

Posts: 10


View Profile
« Reply #4 on: January 08, 2008, 07:19:11 PM »

Does allow you to tune database usage?
Well, sort of.

What I mentioned is more like a protection state the site can enter into if the server load becomes too great. Your choices are this...

-If the system’s 1-minute load average exceeds a certain value, the board will automatically go offline.
-If the number of sessions exceeds a certain value within a one minute period the board will go offline.
(These can help keep bandwidth over-usage fees under control.)

On the other hand, you can control database load by controlling what general things are displayed on your board. That is, things that must rely on the database such as...

-Store read/unread status in cookies or in database.
-Display read/unread status for guests.
-Display online user information on index, forum and topic pages.
-Disabled the birthday listing.
-Enable display of moderators.
-Enable display of jumpbox.
-Show user’s activity.
-Displays active topic/forum in user profiles and user control panel. (It is recommended to disable this on boards with more than one million posts.)
-Recompile stale style components.
-Check for updated style components on filesystem and recompile.
-Display custom profile fields in user profiles.
-Display custom profile fields on topic pages.

You guys may be able to control a lot of those things already with any forum. It all contributes to database load/activity.
Logged

thughes
Jr. Member
**
Offline Offline

Posts: 96


View Profile
« Reply #5 on: January 09, 2008, 09:06:34 AM »

Ah, yes. That does seem similar to many of the features currently in vBulletin and some other packages.  I think some of the things you list are read from the cache and not pulled direct from the db each time.
Logged
Pages: [1]
  Print  
 
Jump to: