Page 1 of 1

easy tweak for phpBB with 285mb MYSQL DB

Posted: Thu Sep 28, 2006 3:45 pm
by xmutan
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.

Posted: Thu Sep 28, 2006 4:20 pm
by Vic D'Elfant
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

Posted: Fri Sep 29, 2006 2:08 am
by xmutan
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

Posted: Fri Sep 29, 2006 2:44 am
by drathbun
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.