Search found 426 matches

by 1234homie
Tue Apr 19, 2011 6:23 pm
Forum: phpBB Discussion
Topic: Best phpbb forum host?
Replies: 10
Views: 4337

Re: Best phpbb forum host?

I highly recommend to use your own dedicated server ;]
by 1234homie
Tue Apr 19, 2011 6:14 pm
Forum: [3.0.x] Support Forum
Topic: Optimization of Upgraded phpBB forum???
Replies: 7
Views: 1103

Re: Optimization of Upgraded phpBB forum???

firstly turn ON GZip - its imporant to send gzipped content to user ;] next edit all files and delete unused functions and any other codes than tuning your /etc/my.cnf file via ssh and tune up your sql. After all you can optimize queries in slowlog etc.

Regards
by 1234homie
Sun Apr 17, 2011 8:11 pm
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 48696

Re: [3.0.x] Tweaks for large forums

So I should cache post counts in users table and run query only if its less than X user posts? not exactly. post count is *already* in users table, and query *already* runs only if post count is less than something. done and working very well :D Anyone have ideas how tweak this mod http://www.phpbb...
by 1234homie
Thu Mar 17, 2011 5:40 pm
Forum: [3.0.x] Abandoned MODs
Topic: [ABD] Real Upload Progress Bar v2.0.2
Replies: 125
Views: 26043

Re: Real Upload Progress Bar v2.0.1

any demo?
by 1234homie
Sat Mar 12, 2011 12:31 pm
Forum: [3.0.x] Support Forum
Topic: Disable registration with ten minute mail addresses
Replies: 3
Views: 1286

Re: Disable registration with ten minute mail addresses

stevemaury wrote:This is a waste of time.
why?
by 1234homie
Mon Feb 21, 2011 6:02 pm
Forum: [3.0.x] MODs in Development
Topic: [Beta] Sphinx search for phpBB 1.0.beta2
Replies: 294
Views: 91980

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Any news about new version?
by 1234homie
Thu Jan 06, 2011 2:09 am
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 48696

Re: [3.0.x] Tweaks for large forums

PS. what about topic_posted column in topics_posted table, I think its needless ;p Really ? Can I delete this column or it will cause some problems ? DON'T delete that column. It gains virtually nothing and will cause code to break without modification. I say this with all due respect to the author...
by 1234homie
Tue Jan 04, 2011 6:12 pm
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 48696

Re: [3.0.x] Tweaks for large forums

There's no real way to optimize that because of everything the query has to do. By default, the activity query is not run for users having > 5000 posts, you may wish to tweak that number in display_user_activity() in includes/functions_admin.php I need it for all users :D I work on it and I minimiz...
by 1234homie
Mon Jan 03, 2011 7:58 pm
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 48696

Re: [3.0.x] Tweaks for large forums

PS. Anyone trying to optimize this query? In: functions_display.php (user activity in profiles) SELECT forum_id, COUNT(post_id) AS num_posts FROM phpbb_posts WHERE poster_id = 2 AND post_postcount = 1 AND forum_id NOT IN (forums) GROUP BY forum_id ORDER BY num_posts DESC LIMIT 1 query time: 13 sec :...
by 1234homie
Mon Jan 03, 2011 7:55 pm
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 48696

Re: [3.0.x] Tweaks for large forums

PS. what about topic_posted column in topics_posted table, I think its needless ;p Really ? Can I delete this column or it will cause some problems ? omg Don't delete it! xD It's require changes in some files... I only propose to do something with this column becouse in my opinion its not useful ;p...
by 1234homie
Tue Dec 28, 2010 5:06 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: time() in page_header
Replies: 2
Views: 57

Re: time() in page_header

Paul wrote:page_header is not in a class, so $this can not be used?
oh im sorry, I pasted the wrong code xD of course I mean $user->time_now. First post edited ;p
by 1234homie
Tue Dec 28, 2010 4:50 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: time() in page_header
Replies: 2
Views: 57

time() in page_header

Hi, I think why we use time() here: 'CURRENT_TIME' => sprintf($user->lang['CURRENT_TIME'], $user->format_date(time(), false, true)), instead of: 'CURRENT_TIME' => sprintf($user->lang['CURRENT_TIME'], $user->format_date($user->time_now, false, true)), $user->time_now is seen to work faster then call ...
by 1234homie
Tue Dec 21, 2010 9:29 pm
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 48696

Re: [3.0.x] Tweaks for large forums

PS. what about topic_posted column in topics_posted table, I think its needless ;p
by 1234homie
Tue Dec 21, 2010 9:25 pm
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 48696

Re: [3.0.x] Tweaks for large forums

sry bad post pls delete
by 1234homie
Sat Dec 18, 2010 9:56 pm
Forum: phpBB Discussion
Topic: [3.0.x] Tweaks for large forums
Replies: 204
Views: 48696

Re: [3.0.x] Tweaks for large forums

If you have a busy forum where topics are locked but not deleted, it's a nonissue.
If you have a busy forum where topics are deleted often, it's a major issue.
yep but if your users write 100 posts per minute, update == 15 seconds... I dont recommend it ;p

Go to advanced search