Question Slow forum
- Thread starter madness85
- Start date
- Status
Thank you for replying. Ive disabled that addon and its still slow.
Ive installed slow query logging.
Default settings ok?
Slow query threshold (seconds) 1
Slow transaction threshold (seconds) 1.5
Just checked and it's not enabled.
I created a copy of my forum to try find the problem. Ive removed items one by one and checked the speed.
Any items that have permissions or change usergroup have a serious impact on the loading speed:
Items removed
usergroup permissions
can bank
steal more
steal chance
can steal
usergroup change
3 x items
Page load: 1.1050s
There's nothing in the queries that would suggest that, unless the stats are lying and each of the permissions queries like
Actually take a lot longer.
Do you have a separate web and database server? If your MySQL connection is remote, then it's possible that the stats aren't taking connection time into consideration.
For instance, if it takes 0.0002 seconds to run a query, but 0.5 seconds to connect to the database in order to run the query then the
Code:
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 457, dbtech_shop_item, 3
Run Time: 0.000287Do you have a separate web and database server? If your MySQL connection is remote, then it's possible that the stats aren't taking connection time into consideration.
For instance, if it takes 0.0002 seconds to run a query, but 0.5 seconds to connect to the database in order to run the query then the
EXPLAIN would say 0.0002 seconds, not 0.5002 seconds.Nope all on same server. I don't know if its the more popular the item is, the more effect it has on index.php, or if i continue adding its going to get slower and slower.
Atm without a solution it looks like i will need to abandon this. That means i have no shop and credits
Its defiantly items causing the issue.
@
Items:
(can bank) 8 purchase 1 active
(can steal) 7 purchase 1 active
Usergroup permissions that make changes to the shops own permissions have a huge effect.
Found the issue.
Items:
(can bank) 8 purchase 1 active
(can steal) 7 purchase 1 active
Usergroup permissions that make changes to the shops own permissions have a huge effect.
Sorry I'm not sure what exactly you're saying, can you clarify please?
Are you saying the issue is in the "Usergroup Permissions" item, but only if that item is overriding certain permissions?
If so, can you please share the item config with me (screenshots of every part of the AdminCP item screen is fine)?
Are you saying the issue is in the "Usergroup Permissions" item, but only if that item is overriding certain permissions?
If so, can you please share the item config with me (screenshots of every part of the AdminCP item screen is fine)?
Hope this helps i cant do anymore:
Queries 81 Time 3.0468s
Removed:
Usergroup Permissions (Yes / No)
(can bank) 8 purchase 1 active
(can steal) 7 purchase 1 active
Results: Queries 79 Time 1.3829s
Removed:
Usergroup Change
(item id 2) purchase 35 active 19
(item id 4) purchase 1 active 0
(item id 5) purchase 0 active 0
Results: Queries 75 Time 1.4169s (not really changed)
Removed:
(Change Username Style) 4 purchase 4 active
(User Title Change) 3 purchase 3 active
(steal chance) 4 purcase 4 active
(steal more) 4 purcase 4 active
(Immunity) 1 purchase 1 active
(sticky thread) 1 purchase 1 active
Result: Queries 71 Time 0.9980s
I don't understand what this means. Can you please take screenshots of the item configuration?
Removed:
Usergroup Permissions (Yes / No)
(can bank) 8 purchase 1 active
(can steal) 7 purchase 1 active
Will explain.
2 items that change usergroup permissions.
1 can steal
2 can bank
From the database 8 people have purchased (can steal) and only 1 is active.
- Status
Similar threads
- Locked
- Support ticket
- Locked
- Support ticket