easy tweak for phpBB with 285mb MYSQL DB

The 2.0.x discussion forum has been locked; this will remain read-only. The 3.0.x discussion forum has been renamed phpBB Discussion.
Locked
xmutan
Registered User
Posts: 26
Joined: Thu Feb 16, 2006 1:14 pm
Contact:

easy tweak for phpBB with 285mb MYSQL DB

Post by xmutan » Thu Sep 28, 2006 3:45 pm

hi, i'm from indonesia, i have forum with more than11000 members, and user online at the same time about 30 - 60 users, gzip on, using shared hosting(site5), and my site load is very slow, and the server load oftenly high. anyway to tweak my forum so that my forum will took less time lo load? cause i don't understand to tweak my forum using this: http://www.phpbb.com/phpBB/viewtopic.php?t=135383

and my phpbb_search_wordmatch database size is very huge: 150mb. Is that normal?

thanks before.

Vic D'Elfant
Former Team Member
Posts: 6203
Joined: Sun May 02, 2004 6:21 pm
Location: NL, Maastricht
Contact:

Post by Vic D'Elfant » Thu Sep 28, 2006 4:20 pm

The fact that you're using shared hosting may be the reason of the slowdowns. You don't know how many resources the other websites on your server are using. For a website of that size, I'd recommend to get a dedicated server instead of some shared hosting plan. For more information, see http://www.webhostingtalk.com.

I'd also recommend to disable GZip as that adds some extra processing on both server and client side; you'll only have to enable it if you are using too much bandwidth (which would be another reason to get your own box).

In my opinion, the tweaks in the topic you linked to are pretty straight-forward.. that is, if you have some experience with modifying phpBB.

The phpbb_search_wordmatch table is one of the largest tables in a phpBB database, that's normal :)

Vic
midd.ag • DTP, web development & printing
http://www.midd.ag

xmutan
Registered User
Posts: 26
Joined: Thu Feb 16, 2006 1:14 pm
Contact:

Post by xmutan » Fri Sep 29, 2006 2:08 am

will this mod (eXtreme Styles mod) help to speed up my site without making my server load become higher?
http://www.phpbbstyles.com/viewtopic.php?t=356

are there any other way to make the database become smaller without pruning the forum?

thanks

User avatar
drathbun
Former Team Member
Posts: 12204
Joined: Thu Jun 06, 2002 3:51 pm
Location: TOPICS_TABLE
Contact:

Post by drathbun » Fri Sep 29, 2006 2:44 am

If you have that many users, ask each of them to donate a dollar. Half of them will not, maybe more, but you'll have enough to upgrade your host. :-)

eXtreme Styles is supposed to help, it caches the template structure. Not the data, of course, just the structure. If you have added any database-hungry (meaning lots of queries) MODs you can remove them. If you have not, there are still some queries you can remove from the standard phpBB to save some time. One article from the Knowledge Base here might help. Also ditching the "Who's Online" block is easy to do and saves some queries on your index page.
I blog about phpBB: phpBBDoctor blog
Still using phpbb2? So am I! Click below for details
Image

Locked

Return to “2.0.x Discussion”