Page 14 of 14

Re: [3.0.x] Tweaks for large forums

Posted: Wed May 30, 2012 8:02 pm
by evepowr
Well I'm more of a graphical editor. Care to share which one you guys think i should do and the best way to do it. I would like to keep subscribing to topics but that posting lag just kills it.

Re: [3.0.x] Tweaks for large forums

Posted: Wed May 30, 2012 10:46 pm
by Pony99CA
If somebody has that many banned users, I have to wonder if they're banning spammers instead of deleting them. Banning spammers is silly; spammers should be deleted and, if necessary, their usernames should be disallowed.

Steve

Re: [3.0.x] Tweaks for large forums

Posted: Wed May 30, 2012 11:29 pm
by evepowr
Yea it seems to be just user names. I can clear the banned users since i do ban them by ip as well, but will it slow down from the ips as well?

Re: [3.0.x] Tweaks for large forums

Posted: Thu May 31, 2012 1:57 am
by Pony99CA
evepowr wrote:Yea it seems to be just user names. I can clear the banned users since i do ban them by ip as well, but will it slow down from the ips as well?
You should only ban by IP if you see the same IP address/range a lot or if you don't care about traffic from a particular country/ISP.

As for the above query slowing down, notifications aren't done by IPs, so removing banned users should speed things up.

Steve

Re: [3.0.x] Tweaks for large forums

Posted: Thu May 31, 2012 12:50 pm
by evepowr
Yea thats what i assumed just wasn't sure 100%, and wanted to get a quick verification. I already have a few countries blocked.

Re: [3.0.x] Tweaks for large forums

Posted: Sat Jul 13, 2019 4:41 pm
by MaxHayman
arod-1 wrote:
Fri Oct 08, 2010 9:08 pm
evepowr wrote:Anyone work on removing the Inactive users part from the main admin page. It takes forever to load it.

SELECT *
FROM phpbb_users
WHERE user_type = 1
ORDER BY user_inactive_time DESC
LIMIT 10

SELECT * FROM phpbb_users WHERE user_type = 1 ORDER BY user_inactive_time DESC LIMIT 10
Id Select Type Table Type Possible Keys Key Key Len Ref Rows Extra
1 SIMPLE phpbb_users ref user_type user_type 1 const 46874 Using where; Using filesort

Before: 5.97781s | After: 62.00491s | Elapsed: 56.02709s
how about a small experiment - try to index user_inactive_time ?
something like this (this is from memory - you might want to verify that it actually work)
you can add the index, measure the timing, and if it doesnt help, remove the index:
to add:

Code: Select all

alter table phpbb_users add index user_inactive_time (user_inactive_time);
to remove:

Code: Select all

alter table phpbb_users drop index user_inactive_time; 
Had to do this to mine! Works great!

Re: [3.0.x] Tweaks for large forums

Posted: Sat Jul 13, 2019 5:57 pm
by david63
This is a seven year old topic and I would be extremely cautious as to whether it would work with phpBB 3.2 as there have been many changes to the database since 3.0

Re: [3.0.x] Tweaks for large forums

Posted: Mon Jul 15, 2019 10:58 am
by Mick
Plus there is no longer any support for 3.0 so if it all goes peculiar you will be on your own.

Re: [3.0.x] Tweaks for large forums

Posted: Mon Jul 15, 2019 11:04 am
by warmweer
Mick wrote:
Mon Jul 15, 2019 10:58 am
Plus there is no longer any support for 3.0 so if it all goes peculiar you will be on your own.
haha, I like that one: It's not broken, it just went peculiar ;)

added: that's now my new signature :lol:

Re: [3.0.x] Tweaks for large forums

Posted: Mon Jul 15, 2019 11:20 am
by Mick
:D Your welcome👍🏼