Icy Phoenix

This query repit a lot off:
11979542 portalpe_ localhost portalpe_p 0 Query UPDATE phpbb_users SET user_active = 1 WHERE user_id = '2'
11979543 portalpe_ localhost portalpe_p 0 Query UPDATE phpbb_users SET user_active = 1 WHERE user_id = '2'
11979545 portalpe_ localhost portalpe_p 0 Query UPDATE phpbb_users SET user_active = 1 WHERE user_id = '2'

This queries take a lot of time(the five column is the time taked):

11979494 portalpe_ localhost portalpe_p 1 Query SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_fr
11979516 portalpe_ localhost portalpe_p 2 Query SELECT u.username, u.user_point, u.user_id, u.user_posts, u.user_f
11979519 portalpe_ localhost portalpe_p 2 Query SELECT u.username, u.user_point, u.user_id, u.user_posts, u.user_f
11979521 portalpe_ localhost portalpe_p 2 Query SELECT u.username, u.user_point, u.user_id, u.user_posts, u.user_f
11979534 portalpe_ localhost portalpe_p 2 Query UPDATE phpbb_users SET user_active = 1 WHERE user_id = '2'
11979493 portalpe_ localhost portalpe_p 3 Query SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id
11979514 portalpe_ localhost portalpe_p 3 Query SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id
11979518 portalpe_ localhost portalpe_p 3 Query SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id


Could you explain how can i avoid this? maybe is a module that i can disable?

This is de forum: www.portalpez.com
Has 7000 visits per day.


Edit:

I disable cashmod... still have karma mod active.

Please also disable "Main Admin Account Protection" as it is pretty unuseful.

Other queries unfortunately I can't tell where they are from... I would need some other details.

What I can suggest is to disable the "Online Block" in Forum Index for guests (you can do it in ACP => Settings => Icy Phoenix => Forum), then every user should enable it in its own profile to have that block shown.

Also disable UPI2DB or allow it only for admins and moderators (maybe users with more than 100 posts...).

Disable also things you don't really need in ACP => Settings => Icy Phoenix => SQL Charge.

Thanks you Mighty Gorgon!!!

This queries are due to Main Admin Account Protection, so i disabled.

Quote:

This query repit a lot off:
11979542 portalpe_ localhost portalpe_p 0 Query UPDATE phpbb_users SET user_active = 1 WHERE user_id = '2'
11979543 portalpe_ localhost portalpe_p 0 Query UPDATE phpbb_users SET user_active = 1 WHERE user_id = '2'
11979545 portalpe_ localhost portalpe_p 0 Query UPDATE phpbb_users SET user_active = 1 WHERE user_id = '2'

The following queries are due to cash mod, so i disabled...

Quote:

11979494 portalpe_ localhost portalpe_p 1 Query SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_fr
11979516 portalpe_ localhost portalpe_p 2 Query SELECT u.username, u.user_point, u.user_id, u.user_posts, u.user_f
11979519 portalpe_ localhost portalpe_p 2 Query SELECT u.username, u.user_point, u.user_id, u.user_posts, u.user_f
11979521 portalpe_ localhost portalpe_p 2 Query SELECT u.username, u.user_point, u.user_id, u.user_posts, u.user_f

And i think this is due to recent topics... this module was active in all post and forums... so i disabled.

Quote:

11979493 portalpe_ localhost portalpe_p 3 Query SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id
11979514 portalpe_ localhost portalpe_p 3 Query SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id
11979518 portalpe_ localhost portalpe_p 3 Query SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id

Upi2db is only for admins and moderators...
The forum now go well. Thanks you.