Slow mysql-Performance

[Haschn]

Hi there,

after installation of WWH the sql performance went down. Because I was not sure was the cause was, I logged in mysql slow-queries and the result was everytime a wwh-related query:

Code: Select all

                FROM phpbb3_users u
                LEFT JOIN phpbb3_wwh w
                        ON u.user_id = w.id
                WHERE (u.user_type = 2
                                AND u.user_id != 1
                                AND u.user_lastvisit > 1200265200
                                AND u.user_lastvisit > 1)
                        OR (u.user_id = w.id)
                ORDER BY u.username_clean ASC;

So everytime the forum was full of users the speed dramatacally dropped down. After removing WWH all seems to be fine. Any hints here?

I use wwh 6.0.4.

[nickvergessen]

In the new version we add a index to the id.
This was already mentioned by Mahony from phpbb.de
Yoiu can try and run the following code in phpmyadmin:

Code: Select all

ALTER TABLE phpbb_users ADD INDEX (user_id);
ALTER TABLE phpbb_wwh ADD INDEX (id);

[Haschn]

Okay thank you, it seems to work. What does it do exactly?

[nickvergessen]

It adds a index to the column.
so reading it is much faster