Search found 148 matches

by lanzer
Thu May 13, 2004 10:20 am
Forum: 2.0.x Discussion
Topic: How big is the phpbb.com database? / How big is yours?
Replies: 158
Views: 34165

Holy Monster Database, Batman! 50GB and counting! How often do you backup your DB, and what do you back it up onto? How long does it take to do a backup on a DB that size? Because there are mirrored database running, the need for constant backup isn't as great. However, backups are still done on a ...
by lanzer
Tue May 11, 2004 2:21 am
Forum: 2.0.x Support Forum
Topic: Hi...need URGENT help
Replies: 12
Views: 691

Hello Lokirj: If you're having trouble with performance, first thing to do is to install a PHP accelerator. Look for APC2 or mmcache. Just slap it in and watch your board's performance go up by 4 times. Don't worry about memory usage. You're running dynamic pages and your memory usage will always be...
by lanzer
Wed May 05, 2004 2:03 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631581

Hi Alphamoney: If you're interested in running R45's scripts at night but don't have access to CRON, what you can consider doing is to setup your own PC with a macro and access a certain php file on your web site at certain times of the day. Hey, whatever works! :wink: The symptoms: my server has fo...
by lanzer
Mon Apr 26, 2004 11:18 am
Forum: 2.0.x Discussion
Topic: How big is the phpbb.com database? / How big is yours?
Replies: 158
Views: 34165

This is from the admin screen: Number of posts: 64196551 Posts per day: 148388.49 (yesterday was 856159) Number of topics: 1111378 Topics per day: 2568.92 Number of users: 534028 Users per day: 1234.39 Board started: 18 Feb 2003 12:00 pm Avatar directory size: 10.57 KB Database size: 49804072634 Gzi...
by lanzer
Mon Apr 26, 2004 11:01 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631581

Hi Ramius, in terms of the pagination code, yes, it is quite taxing to grant the ability for users to jump to the middle of the thread. The only reason for me to have kept this feature is because I have a dedicated server used to display old messages. It's one of 5 database servers we have on Gaia t...
by lanzer
Tue Apr 06, 2004 10:37 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631581

Hi Steve: Yes, as you might have noticed from R45's post, the new post notification can be sped up greatly by specifying a cap. Hope version 2.2 would incorporate that change when you turn the new post notification on. For my own site I'm going to get rid of that feature all together because every f...
by lanzer
Sat Mar 27, 2004 12:38 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631581

Just when I thought I have all the slow queries replaced, today I found out that the forum and topic synchronizing scripts are taking 5 minutes to complete... Time to split those queries up! Here are the resulting codes under functions_admin.php, within the case statement for the function called syn...
by lanzer
Wed Mar 24, 2004 12:08 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631581

Question: Has anyone with a really large forum tried the Zend optmizer? I have seen a bit about it lately, and I was wondering if it has any positive effects. If it does what it claims (that sounds harsh, I just mean if it works) it might save someone a lot of money that would otherwise be spent on...
by lanzer
Wed Mar 24, 2004 12:02 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631581

Sorry I still haven't got time to put together my notes on how I setup my cluster setup yet, but in a nutshell, I ended up with a setup where I have 3 slave servers and one master. One slave would be dedicated to handle search functions and all old message queries that would take more than ~0.2 seco...
by lanzer
Thu Mar 18, 2004 8:23 pm
Forum: [2.0.x] MOD Requests
Topic: x10 performance improvement in SEARCH???
Replies: 2
Views: 311

Hi Steve: As the idea of indexing topics instead of posts is sound as it keeps the range of targets low, in practice the result of topic indexing versus post indexing is still a word table and a word match table that is quite similar in size. The only difference is that the word match table would ha...
by lanzer
Fri Mar 12, 2004 8:02 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631581

on alot of other sites that say phpbb sucks, you have to be kidding me it runs great, also nice tweaks and great forum, mine is about 21k nothing close to yours, but as soon as i get somewhat big I'd like to have it tweaked alot to make it much quicker, do you have a dedicated server for your forum...
by lanzer
Sun Feb 22, 2004 11:08 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631581

Hey Ianzer, Regarding the searching operations, why not just use google (like php.net and an increasing amount of other sites do). Aside: I also sent an e-mail to the address you in your help wanted post :wink: Hi NativeMind, Google is a great alternative for forums which are more information based...
by lanzer
Sun Feb 22, 2004 8:24 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631581

Mekara Beamu wrote: ... Can you give me a general idea of how your avatars work? ...


Hi Mekara Beamu:

To stay on topic for this thread, if you have any inqiries related to Gaia, please PM me or send us a e-mail through http://www.go-gaia.com/feedback.php

Thank you. :wink:
by lanzer
Sun Feb 22, 2004 8:19 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631581

Out of curiousity, when building the wordmatch table, is there any design or performance reason why a check could not be made of a word in a new or edited post to see if it is a common word (with a word_common value of 1 in the wordlist table) before creating a new entry in the wordmatch table? Cou...
by lanzer
Tue Feb 10, 2004 6:20 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 631581

lanzer i pmed u, im confused on what to edit on the firts post because my forum goes pretty slow Hello to all: Just a small note to anyone who wish to run their phpbb faster. If your forum is running slow, the best place to start would be to post in the support forum, with as much technical detail ...

Go to advanced search