Search found 149 matches

by qspypl
Wed Oct 29, 2008 6:22 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621778

Re: [2.0.x] Tweaks for large forums

da_badtz_one i read couple articles about group by vs distinct after ur post and it looks like there should be no diffirence like you said but there is in filesort. mysql> explain SELECT DISTINCT sql_no_cache topic_id FROM phpbb_posts WHERE post_id IN ( 5204899, 5204820, 5156469, 5204521); +----+---...
by qspypl
Fri Oct 24, 2008 4:53 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621778

Re: [2.0.x] Tweaks for large forums

Thx Dog Cow for this session NOT IN hack.
by qspypl
Fri Oct 10, 2008 4:47 pm
Forum: 2.0.x Support Forum
Topic: Duplicate entry 'xxx' for key 1 (phpbb design flaw?)
Replies: 10
Views: 2057

Duplicate entry 'xxx' for key 1 (phpbb design flaw?)

Our forum is very popular and i think this causing problems. If we look on code below screenshot, we will see $search_id is randomized. I think this error come's when mt_rand() give same result at some point. Error comes randomly from time to time (what proves above theory) and dissapear when search...
by qspypl
Thu Oct 02, 2008 2:42 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621778

Re: [2.0.x] Tweaks for large forums

After using sphinx around ~1 month now, we notice 11% more possible online users on our machine. Last query in slow-queries.log, which appear every couple minutes. I was testing it and still not developed any optimization so i put it here: # Query_time: 5 Lock_time: 0 Rows_sent: 16 Rows_examined: 44...
by qspypl
Fri Aug 22, 2008 10:09 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621778

Re: [2.0.x] Tweaks for large forums

Dont want be rude but i developed it already at page 72 in this topic da_badtz_one
Bottom of my big post :P.

I put so much queries there u could miss it.

Code: Select all

http://www.phpbb.com/community/viewtopic.php?p=4697685#p4697685
by qspypl
Wed Aug 20, 2008 10:47 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621778

Re: [2.0.x] Tweaks for large forums

performance of include, include_once, require, require_once: http://blog.arh.cc/index.php?/archives/8-File-include-performance-in-PHP.html found benchmark like this but not sure if its valuable, my question is this, if we should remove number of files in phpbb by remove'ing include'ing for example: ...
by qspypl
Mon Aug 18, 2008 4:50 am
Forum: 2.0.x Support Forum
Topic: post_username in phpbb_posts, unused?
Replies: 2
Views: 187

Re: post_username in phpbb_posts, unused?

Dont know it till now :) so there is still some areas in phpbb that im not explored yet :P, great!
Thank you very much, regards.
by qspypl
Mon Aug 18, 2008 4:45 am
Forum: 2.0.x Support Forum
Topic: post_username in phpbb_posts, unused?
Replies: 2
Views: 187

post_username in phpbb_posts, unused?

Hello,
From what i see this field in database isn't used anymore (post_username in phpbb_posts) but it still exist in mysql_schema.sql in phpbb 2.0.23.

Am i wrong, or developers forgot to throw it away long time ago?

Regards
by qspypl
Sun Aug 17, 2008 11:54 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621778

Re: [2.0.x] Tweaks for large forums

Quite good summaring Dog Cow. Btw im curious what method of including cache'd data from file to variable is fastest: 1. ob_start(); require_once( 'cache/users.php'); $users = ob_get_contents(); ob_end_clean(); $total_users = $users; 2. $file = implode('', file('cache/users.php')); $total_users = $fi...
by qspypl
Fri Aug 01, 2008 6:56 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621778

Re: phpBB tweaks for large forums

Can you post some notes on how to get sphinx going? This is esentially five simple steps. 1. Download source: http://www.sphinxsearch.com/downloads/sphinx-0.9.8.tar.gz 2. Extract and ./configure & make & make install, edit /usr/local/etc/sphinx.conf 3. After configuration run /usr/local/bin/indexer...
by qspypl
Thu Jul 31, 2008 5:49 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621778

Re: phpBB tweaks for large forums

Ok im sphinxed right now : d, posting 20-30 times faster because dropped full text indexes, searching is instant maximum 0.5 (over 800.000 results), average below 0.1 on 3.8 m posts table. Today final performance tests on full load. Now must only pagination move to sphinx and i will be rdy for next ...
by qspypl
Tue Jul 29, 2008 4:07 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621778

Re: phpBB tweaks for large forums

When you will be ready/have a link let us know.
Btw anyone rewrited search.php from phpbb2 to work with sphinxapi? I would be happy if someone could share it.
by qspypl
Mon Jul 28, 2008 3:55 am
Forum: 2.0.x Support Forum
Topic: Mod for make'ing new usernames more restrict
Replies: 5
Views: 278

Re: Mod for make'ing new usernames more restrict

instructions expired :P
by qspypl
Sun Jul 27, 2008 5:36 am
Forum: 2.0.x Support Forum
Topic: Mod for make'ing new usernames more restrict
Replies: 5
Views: 278

Re: Mod for make'ing new usernames more restrict

Done, nicknames from 2 to 13 character. Only letters and numbers.
Password from 5 to 32 characters.

Regards.
by qspypl
Sun Jul 27, 2008 12:13 am
Forum: 2.0.x Support Forum
Topic: Mod for make'ing new usernames more restrict
Replies: 5
Views: 278

Re: Mod for make'ing new usernames more restrict

I will never upgrade to 3.0 coz too much modifications we create at 2.0 and 3.0 dont offer us anything new. I cant find too such modification so only solution for me its to write it alone :).

Thanks for help though, regards.

Go to advanced search