Search found 370 matches

by da_badtz_one
Fri Feb 05, 2010 7:07 pm
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 44103

Re: [3.0.x] Tweaks for large forums

I think that PHP interpretation is the bottleneak. I seem to get quite good speed with MySQL atm. are you running with all the php accelerators/optimizers? if not, i think using maximum acceleration/optimization/caching in php as a first step makes much more sense than going in the direction of com...
by da_badtz_one
Fri Feb 05, 2010 2:55 pm
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 44103

Re: [3.0.x] Tweaks for large forums

I think that PHP interpretation is the bottleneak. I seem to get quite good speed with MySQL atm.

Thanks for the reply A_Jelly_Doughnut.
by da_badtz_one
Fri Feb 05, 2010 1:37 pm
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 44103

Re: [3.0.x] Tweaks for large forums

Has anyone heard about Hip hop? http://developers.facebook.com/news.php?blog=1&story=358 This is something Facebook made that translates PHP into C++ and then compiles it with a compiler (gcc or *fingers crossed* even the Intel compilers). Personally I would love to be able to put phpBB3 into it but...
by da_badtz_one
Sat Oct 25, 2008 4:34 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 617549

Re: [2.0.x] Tweaks for large forums

@qspypl: I'm surprised adding distinct will actually speed things up. DISTINCT is infact a GROUP BY in most cases. I guess one way you can avoid using DISTINCT or GROUP BY all together is to take a 100 max result limit instead and find the first 30 unique topic ids. You can use array_unqiue or even ...
by da_badtz_one
Tue Aug 26, 2008 11:43 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 617549

Re: [2.0.x] Tweaks for large forums

I respectively disagree with arod-1. There is much to gain even from just splitting the posts table into many smaller tables. I agree that if we split the posts table into smaller tables on one server would have little effect. But having these tables over a number of servers will certainly help dist...
by da_badtz_one
Sun Aug 24, 2008 3:21 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 617549

Re: [2.0.x] Tweaks for large forums

woops, sorry there qspypl.

@A_Jelly_Doughnut: Thanks. Though I am surprised that I get a faster result even with innodb as I remember reading somewhere that innodb tables did not cache the total number of entries.
by da_badtz_one
Fri Aug 22, 2008 5:53 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 617549

Re: [2.0.x] Tweaks for large forums

There are some great comments getting thrown around here, thanks to Dog Cow especially for writing up that guide. I'd like to share a tweak I made a while ago which I forgot to share. The following query is a query you'll find when trying to find the total count of every user in your database to pro...
by da_badtz_one
Wed Jun 25, 2008 9:59 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 617549

Re: phpBB tweaks for large forums

I've got the ACM cache class running on phpBB 2 right now. It's a dandy and very easy to convert. this is very interesting. can you do us all a favor and try to run a large and busy board with and without phpbb3 style caching? i always had a strong suspicion that the phpbb3 sql caching does more ha...
by da_badtz_one
Tue Apr 29, 2008 3:48 am
Forum: [2.0.x] MODs in Development
Topic: [BETA2] RTP: Real Topic Pagination
Replies: 5
Views: 1409

Re: [BETA2] RTP: Real Topic Pagination

In file functions_post.php, you added the following query: $sql = "SELECT COUNT(page_id) AS page_max FROM " . POSTS_TABLE . " WHERE page_id = $page_id AND topic_id = $topic_id"; Would it not be more appropriate to use this instead: $sql = "SELECT COUNT(page_id) AS page_max FROM " . POSTS_TABLE . " W...
by da_badtz_one
Thu Apr 10, 2008 10:32 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 617549

Re: phpBB tweaks for large forums

I read a series of MySQL articles last evening, and one tip I read was to never have your MySQl server directly accessible via the Internet. Always have it behind your web/application servers with a firewall. I assume you mean always have a firewall (eg apf) to block the 3306 port that mysql uses?
by da_badtz_one
Thu Apr 03, 2008 9:46 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 617549

Re: phpBB tweaks for large forums

Wow, thanks for that query tweak! mysql> SELECT COUNT(user_id) -1 AS total FROM phpbb_users; +--------+ | total | +--------+ | 868345 | +--------+ 1 row in set (0.80 sec) mysql> SELECT COUNT(user_id) AS total FROM phpbb_users WHERE user_id > -1; +--------+ | total | +--------+ | 868345 | +--------+ ...
by da_badtz_one
Tue Sep 18, 2007 7:59 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 617549

Re: phpBB tweaks for large forums

@EverettB: I have just tried your code and I have made some minor changes to it. Because everything that goes through the clean_words function is strtolowered the stop words should also be strtolowered. It's not something found on the vanilla phpBB2 but it has been a suggestion made in this thread s...
by da_badtz_one
Mon Sep 17, 2007 4:27 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 617549

Re: phpBB tweaks for large forums

I just want to report back on my findings for caching or somehow removing all those updates from the replies to the forum table. What I did was use memcache to cache the query in auth.php file: $sql = "SELECT a.forum_id, $a_sql FROM " . FORUMS_TABLE . " a $forum_match_sql"; This has made a massive r...
by da_badtz_one
Fri Sep 14, 2007 12:04 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 617549

Re: phpBB tweaks for large forums

Thanks Drathbun for sharing that with us. I've added some of the tweaks you've mentioned. Here's a tut for those who didn't get what Drath said in the first para. Find this in search.php: for($i = 0; $i < count($split_search); $i++) { And add before it: $split_search = array_unique($split_search); I...
by da_badtz_one
Thu Sep 13, 2007 5:23 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 617549

Re: phpBB tweaks for large forums

That's one of the reasons why there is batched updating posted here. I have to stress that that kind of batched updating is annoying and would prefer something more instant. I just want to post some of my findings for optimizing the search today. These are mainly to do with the PHP side of things. I...

Go to advanced search