Search found 149 matches

by qspypl
Thu Mar 13, 2008 8:09 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621592

Re: phpBB tweaks for large forums

Well yes they are related somehow in resync process... but we have only one administrator and he dont use any resync options, so they are automatically triggered when accessing admin panel or while moderators make'ing some specific operations... i have this query couple times in every hour in slow-q...
by qspypl
Thu Mar 13, 2008 7:42 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621592

Re: phpBB tweaks for large forums

well im aware of queries cache, i was testing it several times before posting it here when i was searching how to optimize this , first i checked best site about mysql tuning and that was it: http://www.mysqlperformanceblog.com/2007/04/10/count-vs-countcol/ here is everything, they explain why * is ...
by qspypl
Thu Mar 13, 2008 11:17 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621592

Re: phpBB tweaks for large forums

UPDATE: this post turned to tunning up couple queries but need answers for questions and approve'ing of this hacks would be great too Well, just found great hack for me, when your board have many moderators it will be great speed gain. This query we optimizing: # Query_time: 13 Lock_time: 0 Rows_se...
by qspypl
Wed Mar 05, 2008 1:06 pm
Forum: [2.0.x] MOD Requests
Topic: Simple split function mod
Replies: 3
Views: 305

Re: Simple split function mod

because when topic got 300 pages, split function load 300 pages of posts at once (at one page) to select splits...
This function would be great replace of delete function for moderators.
by qspypl
Mon Mar 03, 2008 3:53 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621592

Re: phpBB tweaks for large forums

Ok but i already solve this previous topic thing and add my own modification. Maybe lanzer was same dunno. Dont know if you guys have this problem but at viewforum query when users want see 3000 page of forum (40 topic on each page) they execute query with limit like this: bleble LIMIT 152120, 40 No...
by qspypl
Mon Mar 03, 2008 12:48 am
Forum: [2.0.x] MOD Requests
Topic: Simple split function mod
Replies: 3
Views: 305

Simple split function mod

Hello,
Searching some modification which would work like DELETE function (this in every post) but instead of deleting post after clicked it would splitting it and moving automatically to garbage forum.

Is there anything like this?

Regards
by qspypl
Sat Mar 01, 2008 2:54 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621592

Re: phpBB tweaks for large forums

You may as well have all the template HTML info right in with the raw PHP code. Thats true, one bad side is then code would looke like mess. If it would give even decent speed gains its ok with me but for almost nothing its not worth trying. I was remove'ing from phpbb useless switch/if statements ...
by qspypl
Thu Feb 28, 2008 10:33 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621592

Re: phpBB tweaks for large forums

Got question, i was hardcoding much things, thanks to that i eliminate so many queries and have: index.php [ Czas 0.024 | 3 Queries] viewforum.php [ Czas 0.060 | 7 Queries] viewtopic.php [ Czas 0.038 | 7 Queries] now, security problem arise since i hardcoded querying phpbb_config on EVERY page to si...
by qspypl
Wed Feb 27, 2008 5:15 pm
Forum: 2.0.x Support Forum
Topic: How to disable external login boxes? :C
Replies: 13
Views: 212

Re: How to disable external login boxes? :C

Hmm how often? It depend, but couple times a week. I want disable it automatically not because i must repair this manually often but if user will write his login information in this box they could be stealed.
by qspypl
Wed Feb 27, 2008 3:43 pm
Forum: 2.0.x Support Forum
Topic: How to disable external login boxes? :C
Replies: 13
Views: 212

Re: How to disable external login boxes? :C

It is the other server which is forcing a login before showing its content. You cannot see the image without logging in. Yes, but how to disable it on our server something like if ( external_login_box ) { deny :C } Dunno, need disable automatically this content from other server which request login...
by qspypl
Wed Feb 27, 2008 3:11 pm
Forum: 2.0.x Support Forum
Topic: How to disable external login boxes? :C
Replies: 13
Views: 212

Re: How to disable external login boxes? :C

I assume the other server is requiring a login to see the image.
Yes, but how to disable login from other servers on our.
Edit the post to delete the link.
This is manually job, we want automatic solution here.
by qspypl
Wed Feb 27, 2008 2:22 pm
Forum: 2.0.x Support Forum
Topic: How to disable external login boxes? :C
Replies: 13
Views: 212

How to disable external login boxes? :C

It happen when some linked image from another server got probably some .htacces modified there.
How to prevent this external login boxes from other servers on our forum?
by qspypl
Wed Feb 20, 2008 2:50 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621592

Re: phpBB tweaks for large forums

Amodinos, i found only a little tweak, for me it is from scanning ~340 k records to ~315 k records. Its almost nothing but maybe u interested: EXPLAIN SELECT t.forum_id, t.topic_id, p.post_time FROM phpbb_topics t, phpbb_posts p FORCE INDEX ( post_time ) WHERE p.post_id = t.topic_last_post_id AND p....
by qspypl
Fri Jan 18, 2008 11:22 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621592

Re: phpBB tweaks for large forums

Is forum_id = 6 more than 15-20% of your posts? Yes, exactly 20-25% (128956 topics /535770 posts in id=6) querying page 3000 is horror im now reviewing first pages of this topic to find solution to viewing forums from backward. Dog Cow interesting stuff, can someone test it? I would love to read a ...
by qspypl
Fri Jan 04, 2008 12:21 am
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621592

Re: phpBB tweaks for large forums

I don't see how, the stored result would be inaccurate every time someone posted a new post. Those queries are only run if someone specifically selects to run them so they do not run very often. Aren't those queries count how many topics iso in specific viewforum? So the would run quite often, i mu...

Go to advanced search